Question

1. In Renovation Projection Schedule for The Muisca Room, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in Renovations Started For Median Renovation Length in Days; otherwise, have the word Over display. Use the named range for Renovations Started for Median Renovation Length in Days when entering this function.

2.. In Renovations Started for Monthly Payment, enter a function that will calculate the monthly payment for the loan amount in Renovations Started for Amount of Loan, based on the   Annualized Rate in Renovations Started for Annualized Rate, and the number of years in the Term in Renovations Started for Term (in Years). Display the monthly payment as a positive value.

	Renovations Started	Renovations Completed	Length of Renovations in Days		Original Capacity	New Capacity	Quarterly Revenue Prior to Renovations	Projected Quarterly Revenue after Renovations	Renovation Projection Schedule
The Muisca Room	1/6/2018	5/10/2018			500	650.0	290,000	116,000
The Eldorado Room	3/15/2018	7/15/2018			100	130.0	575,000	230,000
The Pueblo Room	9/10/2018	11/30/2018			25	32.5	225,000	90,000
Technology room 1	8/1/2018	10/1/2018			45	58.5	150,000	60,000
Technology room 2	2/15/2018	4/15/2018			25	32.5	75,000	30,000
Increase in Capacity	30%
Increase in Revenue	40%
Median Renovation Length in Days
Loan Information
Amount of Loan	125,000
Annualized Rate	6%
Term (in Years)	5
Monthly Payment

Answer 1

SOLUTION

FIRST GO TO THE CELL OF RENOVATION PROJECTION SCHEDULE

ENTER THE FORMULA

please note that i dont have original excel sheet, so i used sample one

D4-Length of the Renovation in days

Enter the formula mentioned in the picture

--

all the best