Please show caluculation. Thanks! A store has 5 years remaining on its lease in a mall. Rent is...

Question

Please show caluculation. Thanks!

A store has 5 years remaining on its lease in a mall. Rent is $1,900 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to sell the property in a year and wants rent at that time to be high so that the property will appear more valuable. Therefore, the store has been offered a "great deal" (owner's words) on a new 5-year lease. The new lease calls for no rent for 9 months, then payments of $2,600 per month for the next 51 months. The lease cannot be broken, and the store's WACC is 12% (or 1% per month).

Should the new lease be accepted? (Hint:
Be sure to use 1% per month.)

Answer is NO

If the store owner decided to bargain with the mall's owner over the new lease payment, what new lease payment would make the store owner indifferent between the new and the old leases? (Hint:
Find FV of the old lease's original cost at t = 9, then treat this as the PV of a 51-period annuity whose payments represent the rent during months 10 to 60.) Round your answer to the nearest cent.

$

The store owner is not sure of the 12% WACC "?? it could be higher or lower. At what nominal WACC would the store owner be indifferent between the two leases? (Hint:
Calculate the differences between the two payment streams, and then find its IRR.) Round your answer to two decimal places.

David · Accepted Answer

a. 5 years remaining on lease; rent = $2,000/month; 60 payments left, payment at end of month.�New lease terms: $0/month for 9 months; $2,600/month for 51 months.�Cost of capital = 12% annual (1% per month).�Old Lease New Lease�Year Cash Flow PV at 1% PV
a. 5 years remaining on lease; rent = $2,000/month; 60 payments left, payment at end of month.
New lease terms: $0/month for 9 months; $2,600/month for 51 months.
Cost of capital = 12% annual (1% per month).
Old Lease New Lease
Year Cash Flow PV at 1% PV of cash flow Cash Flow PV at 1% PV of cash flow
1 $2,000.00 0.990 $1,980.20 $0.00 0.990 $0.00
2 $2,000.00 0.980 $1,960.59 $0.00 0.980 $0.00
3 $2,000.00 0.971 $1,941.18 $0.00 0.971 $0.00
4 $2,000.00 0.961 $1,921.96 $0.00 0.961 $0.00
5 $2,000.00 0.951 $1,902.93 $0.00 0.951 $0.00
6 $2,000.00 0.942 $1,884.09 $0.00 0.942 $0.00
7 $2,000.00 0.933 $1,865.44 $0.00 0.933 $0.00
8 $2,000.00 0.923 $1,846.97 $0.00 0.923 $0.00
9 $2,000.00 0.914 $1,828.68 $0.00 0.914 $0.00
10 $2,000.00 0.905 $1,810.57 $2,600.00 0.905 $2,353.75
11 $2,000.00 0.896 $1,792.65 $2,600.00 0.896 $2,330.44
12 $2,000.00 0.887 $1,774.90 $2,600.00 0.887 $2,307.37
13 $2,000.00 0.879 $1,757.33 $2,600.00 0.879 $2,284.52
14 $2,000.00 0.870 $1,739.93 $2,600.00 0.870 $2,261.90
15 $2,000.00 0.861 $1,722.70 $2,600.00 0.861 $2,239.51
16 $2,000.00 0.853 $1,705.64 $2,600.00 0.853 $2,217.34
17 $2,000.00 0.844 $1,688.75 $2,600.00 0.844 $2,195.38
18 $2,000.00 0.836 $1,672.03 $2,600.00 0.836 $2,173.65
19 $2,000.00 0.828 $1,655.48 $2,600.00 0.828 $2,152.12
20 $2,000.00 0.820 $1,639.09 $2,600.00 0.820 $2,130.82
21 $2,000.00 0.811 $1,622.86 $2,600.00 0.811 $2,109.72
22 $2,

Please show caluculation. Thanks! A store has 5 years remaining on its lease in a mall. Rent is $1,900 per month, 60 payments remain, and the next payment is due in 1 month. The mall's owner plans to...

Answer To: Please show caluculation. Thanks! A store has 5 years remaining on its lease in a mall. Rent is...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment