Comments Snart Delete ( Format 8.28-0.4 Sara he Select Yes this Home Insert Draw Page Layout Formulas Data Review View Tell me Calibrl Body 12 - ' General Conditional Format E- 7 Forma Table BI A- $ . % Cel Style Open recovered workbooks Your recent changes were saved. Do you want to continue working where you left off? Add-in Problem Sorry, we couldn't find solver.xlam. Is it possible it was moved, renamed or deleted? 133 fx 1 1 Annual Rental income 26,400 Houses Downpayment 30.000 Borrow 120.000 Total Com 150.000 Interest Rate AN 1 6 1-lan 31 Dec 1-lan 31-Dec 1. 31-Dec 1-lan 31-Dec 1 31-Dec 31-Dec 3-Jan a houses boh 1 1 1 2 total houses owned 1 1 1 1 2 3 1 4 4 6 9 + 10 1. 31-Dec 31-Dec I. 31-Dec 5 14 7 21 10 11 9 14 21 31 26.400 26.400 105,600 79.200 52.8001 B1R 400 5544001 150,400 237,600 369,500 Revenue Expenses interest Insurance Repair / Other Management Fee Profit 4800 1,460 2,500 2.640 15,000 57 4800 1,460 2,500 2,6401 15,000 9600 2.920 5,000 5280 30,000 14400 4,380 7.500 7920 45.000 19200 5,840 10,000 10,560 60.000 28800 8,760 15.000 15 940 90,000 45200 13,140 22.500 23.760 135,000 67200 20440 35.000 36,960 2100001 100000 10660 52 500 55.440 315,000 148800 45,260 77500 81,140 465,000 150,000 150,000 150,000 150,000 300,000 300,000 450,000 450.000 600,000 600,000 900.000 900.000 1.350,000 1,350,000 2,100,000 2,100,000 3,150,000 3,150,000 4,650.000 4,650,000 0 15.000 15.000 30 000 O 30,000 45.000 15.000 25000 15000 105.000 15.000 150.000 0 210.000 0315.000 35,000 450000 150,000 165,000 165.000 180,000 300,000 $10,000 450,000 495,000 615,000 675,000 915,000 1.005.000 1.165,000 1,500,000 2,100,000 2.310,000 3,150,000 3465000 4565.000 5.130.000 Assets Property Cash Total Assets Liabilities Bank loan Louit Jennifer Capital Total Liab Arquity 120,000 120,000 120 000 120,000 240,000 240,000 360,000 360000 40000 480 000 720,000 720 000 100 000 1 000 000 1,680.000 1.650.000 2.520.000 2.520.000 3.720 000 3.720.000 30,000 45.000 45.000 60.000 60000 90000 90000 135,000 135.000 195.000 195.000 285.000 285.000 420,000 420,000 630.000 630000 945.000 945.000 1410000 150,000 165,000 165,000 180.000 300.000 130,000 450,000 495,000 615,000 675,000 915,000 1,005,000 1,165,000 1,500,000 2,100,000 7,110,000 3,150,000 3,465.000 4,645,000 5,130,000 Incorrect Question 6 0/1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) What was revenue for the Year 2014? 2,370.000 7.110,000 2.772.000 4.171.200 Incorrect Question 7 0 / 1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) How much did Jennifer pay the bank for interest in the Year 2013? 277,200 336,000 504,000 12,600,000 Incorrect Question 8 0/1 pts 11 Incorrect Question 8 0/1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) How much did Jennifer's earnings increase from Year 12 to Year 15? 3,555,000 2.505,000 7.500,000 4 408,800 Incorrect 0/1 pts Incorrect Question 9 Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) If Jennifer wanted to reduce expenses in Year 15, what expense would be easiest to control? Interest Expense Insurance Expense Repair Expense Management Fees Incorrect Question 10 0 / 1 pts pts Incorrect Question 10 Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) At the beginning of Year 15, Jennifer had the option to hire two employees to manage all of her properties. This would have allowed her to avoid the 10% of revenue fee the management company is charging her. She would have had to pay each employee $82,000/ year plus 10% in benefits. How much more profit would she have earned in Year 15 if she had hired these two employees and fired the management company? 445.280 180,400 .625,680 461680 Hiring the two employees would have resulted in less profit for Year 15 Comments Snart Delete ( Format 8.28-0.4 Sara he Select Yes this Home Insert Draw Page Layout Formulas Data Review View Tell me Calibrl Body 12 - ' General Conditional Format E- 7 Forma Table BI A- $ . % Cel Style Open recovered workbooks Your recent changes were saved. Do you want to continue working where you left off? Add-in Problem Sorry, we couldn't find solver.xlam. Is it possible it was moved, renamed or deleted? 133 fx 1 1 Annual Rental income 26,400 Houses Downpayment 30.000 Borrow 120.000 Total Com 150.000 Interest Rate AN 1 6 1-lan 31 Dec 1-lan 31-Dec 1. 31-Dec 1-lan 31-Dec 1 31-Dec 31-Dec 3-Jan a houses boh 1 1 1 2 total houses owned 1 1 1 1 2 3 1 4 4 6 9 + 10 1. 31-Dec 31-Dec I. 31-Dec 5 14 7 21 10 11 9 14 21 31 26.400 26.400 105,600 79.200 52.8001 B1R 400 5544001 150,400 237,600 369,500 Revenue Expenses interest Insurance Repair / Other Management Fee Profit 4800 1,460 2,500 2.640 15,000 57 4800 1,460 2,500 2,6401 15,000 9600 2.920 5,000 5280 30,000 14400 4,380 7.500 7920 45.000 19200 5,840 10,000 10,560 60.000 28800 8,760 15.000 15 940 90,000 45200 13,140 22.500 23.760 135,000 67200 20440 35.000 36,960 2100001 100000 10660 52 500 55.440 315,000 148800 45,260 77500 81,140 465,000 150,000 150,000 150,000 150,000 300,000 300,000 450,000 450.000 600,000 600,000 900.000 900.000 1.350,000 1,350,000 2,100,000 2,100,000 3,150,000 3,150,000 4,650.000 4,650,000 0 15.000 15.000 30 000 O 30,000 45.000 15.000 25000 15000 105.000 15.000 150.000 0 210.000 0315.000 35,000 450000 150,000 165,000 165.000 180,000 300,000 $10,000 450,000 495,000 615,000 675,000 915,000 1.005.000 1.165,000 1,500,000 2,100,000 2.310,000 3,150,000 3465000 4565.000 5.130.000 Assets Property Cash Total Assets Liabilities Bank loan Louit Jennifer Capital Total Liab Arquity 120,000 120,000 120 000 120,000 240,000 240,000 360,000 360000 40000 480 000 720,000 720 000 100 000 1 000 000 1,680.000 1.650.000 2.520.000 2.520.000 3.720 000 3.720.000 30,000 45.000 45.000 60.000 60000 90000 90000 135,000 135.000 195.000 195.000 285.000 285.000 420,000 420,000 630.000 630000 945.000 945.000 1410000 150,000 165,000 165,000 180.000 300.000 130,000 450,000 495,000 615,000 675,000 915,000 1,005,000 1,165,000 1,500,000 2,100,000 7,110,000 3,150,000 3,465.000 4,645,000 5,130,000 Incorrect Question 6 0/1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) What was revenue for the Year 2014? 2,370.000 7.110,000 2.772.000 4.171.200 Incorrect Question 7 0 / 1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) How much did Jennifer pay the bank for interest in the Year 2013? 277,200 336,000 504,000 12,600,000 Incorrect Question 8 0/1 pts 11 Incorrect Question 8 0/1 pts Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) How much did Jennifer's earnings increase from Year 12 to Year 15? 3,555,000 2.505,000 7.500,000 4 408,800 Incorrect 0/1 pts Incorrect Question 9 Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) If Jennifer wanted to reduce expenses in Year 15, what expense would be easiest to control? Interest Expense Insurance Expense Repair Expense Management Fees Incorrect Question 10 0 / 1 pts pts Incorrect Question 10 Download the spreadsheet used in the video and extend the analysis out to Year 15. Assume everything in the example is the same (i.e. cost of new houses, loan amounts, interest rate, monthly rental income, expenses, etc.) At the beginning of Year 15, Jennifer had the option to hire two employees to manage all of her properties. This would have allowed her to avoid the 10% of revenue fee the management company is charging her. She would have had to pay each employee $82,000/ year plus 10% in benefits. How much more profit would she have earned in Year 15 if she had hired these two employees and fired the management company? 445.280 180,400 .625,680 461680 Hiring the two employees would have resulted in less profit for Year 15