Ms. Susan is renovating her townhouse for a total price of $18,000. The work will be...

 

Transcribed Image Text:

Ms. Susan is renovating her townhouse for a total price of $18,000. The work will be done in a month and she will start to rent the house to Mr. Sam with a monthly rental of $1,200. For how long time (in months) can Ms. Susan can break even from the renovation cost? (Complete the analysis in MS Excel Sheet and copy your analysis and answer here). Assume: The annual maintenance cost is approximately $1,200. Ms. Susan covers utility and electric bills which are approximately $150 every month. The interest rate is 6%. Present Value = Future Value/(1+i)^n Answer: Ms. Susan is renovating her townhouse for a total price of $18,000. The work will be done in a month and she will start to rent the house to Mr. Sam with a monthly rental of $1,200. For how long time (in months) can Ms. Susan can break even from the renovation cost? (Complete the analysis in MS Excel Sheet and copy your analysis and answer here). Assume: The annual maintenance cost is approximately $1,200. Ms. Susan covers utility and electric bills which are approximately $150 every month. The interest rate is 6%. Present Value = Future Value/(1+i)^n Answer:

Answer rating: 100% (QA)

Ms Susans BreakEven Analysis Excel Spreadsheet A1 Renovation Cost 18000 A2 Monthly Rent 1200 A3 Annu... View the full answer