[2] Finace

Today, the renovation of Donald's restaurant has been completed. Donald calculates that the renovation and other related expenses total $36,000 on the completion date (i.e. today). He believes that the renovation will bring in additional profit for his restaurant.

Donald plans to sell his restaurant after 6 years. He would like to see an effective annual return of 25.3% on his investment (i.e. the renovation).

a) What is the minimum additional level weekly profit (paid at the end of each week) that would need to be generated over the next 6 years for Donald to achieve his return of 25.3%? For the purposes of this part only, assume there are no other additional profits resulting from the renovation.

b) After further consideration, Donald believes that the renovation would also allow him to sell his restaurant for an additional $45,000 in 6 years' time. What is the new minimum additional level weekly profit that would need to be generated over the next 6 years for Donald to achieve his return of 25.3%?

__________________________________________________________________________

Fill the correct values in the blank cells

B D E F G 1 2 INPUTS CALCULATIONS 3 4 a) 5 Renovation cost Return on Investment Years until sale Number of repayments i_52 Effective weekly rate Level weekly profit 6 7 8 Additional sale price b) New level weekly profit 9 10