The car rental business is expanding with new office and a cash flow statement for the first 12 months is needed
A. Complete the table and compute total development cost for all months. Add 20.000 to store infrastructure on month 3 and 5.000 for marketing om month 8. See how total development cost is changing.
B. Compute cost = total development cost + all costs for all 12 months.
C. Compute revenue = total revenues for all 12 months
D. Compute profit=Revenue total cost for all 12 months
E. Compute Commutative profit = month1, month1+month2
F. Compute NPV, ROI, Required capital, estimated payback period
AutoSave HI Cashflow - Protected View - Excel Khalid Al-Otaibi KA File Home Insert Page Layout Formulas Data Review View Developer Help Search Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X L1 X f Month10 A 0 Q R s U Y w X Y z AA 8B AC AL J Month8 Montho Month1 Month2 Month3 Month N Month12 Month5 Month Month 7 Month 9 M Month 11 Month 10 2 Cost 3 Development cost 4 Deposit and Rent 7,500 5 Modifications 12,000 6 Marketing 5,000 Licence + preparations cost 7 5,000 8 Store infrastucture 30,000 Total Development cost Cost Rent 59,500 10 2,5001 2.500 2,500 2,500 2,700 2,835 2,977 3,126 3,282 3,446 3,61 3,799 12 Personnel Manager Car cost 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 13 14 Marketing 300 300 300 300 300 240 192 154 123 98 79 63 15 Utlilities 250 250 250 250 250 250 250 250 250 250 250 250 16 Accountant 100 100 100 100 100 100 100 100 100 100 100 100 17 Total Cost 18 19 Revenue 20 Premium 5,000 5.500 6,050 6,655 4,000 4,400 4.840 5.324 5,856 6,442 7,086 7,795 21 Economy SUV 5,000 3000 7,000 3300 9,800 3630 13,720 3993 19 208 4392.3 26,891 4831.53 37,648 5314.683 52,707 5846.1513 73,789 6430.76643 103,305 7073.843073 144,627 7781.22738 202,478 8559.350118 22 23 Limousine 2000 2400 2880 3456 4147.2 4976.64 5971.968 7166.3616 8599.63392 10319.5607 12383.47284 14860. 16741 24 Total Revenue Profit=Revenue - cost 25 Activate Windows Go to Settings to activate Windows, Commulative Profit Sheet1 26 Sheet2 Sheets + AutoSave HI Cashflow - Protected View - Excel Khalid Al-Otaibi KA File Home Insert Page Layout Formulas Data Review View Developer Help Search Share Comments i PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X L1 X f Month10 A 0 Q R s U Y w X Y z AA 8B AC AL J Month8 Montho Month1 Month2 Month3 Month N Month12 Month5 Month Month 7 Month 9 M Month 11 Month 10 2 Cost 3 Development cost 4 Deposit and Rent 7,500 5 Modifications 12,000 6 Marketing 5,000 Licence + preparations cost 7 5,000 8 Store infrastucture 30,000 Total Development cost Cost Rent 59,500 10 2,5001 2.500 2,500 2,500 2,700 2,835 2,977 3,126 3,282 3,446 3,61 3,799 12 Personnel Manager Car cost 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 1,500 5,000 13 14 Marketing 300 300 300 300 300 240 192 154 123 98 79 63 15 Utlilities 250 250 250 250 250 250 250 250 250 250 250 250 16 Accountant 100 100 100 100 100 100 100 100 100 100 100 100 17 Total Cost 18 19 Revenue 20 Premium 5,000 5.500 6,050 6,655 4,000 4,400 4.840 5.324 5,856 6,442 7,086 7,795 21 Economy SUV 5,000 3000 7,000 3300 9,800 3630 13,720 3993 19 208 4392.3 26,891 4831.53 37,648 5314.683 52,707 5846.1513 73,789 6430.76643 103,305 7073.843073 144,627 7781.22738 202,478 8559.350118 22 23 Limousine 2000 2400 2880 3456 4147.2 4976.64 5971.968 7166.3616 8599.63392 10319.5607 12383.47284 14860. 16741 24 Total Revenue Profit=Revenue - cost 25 Activate Windows Go to Settings to activate Windows, Commulative Profit Sheet1 26 Sheet2 Sheets +
