Submit your three-year company budgeted income statement, balance sheet and 1st year cash budget. For a formatting example, use the attached Final Project Financial Statement Excel file. Add ROI and selected Financial Ratios useful in determining profitability of your business venture. Your deliverable should be 4-6 pages in length. Collaborate with your group using your group discussion board. Your participation in the group discussion is mandatory and is how I will assess your overall group progress and individual contributions.

 Sample Final Project Financial Statements.xlsx

Screen Shot 2019-10-04 at 4.16.12 PM.png

 

 

Transcribed Image Text:

PROJECTED MONTHLY CASH BUDGET FOR BEACH RENTAL CO. - Year 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Sales 2550 2550 7650 7650 7650 7650 2550 $ 38,250 Inflows: Product 1 Rent 500 1500 1500 1500 1500 625 7,125 Product 2 Rent 2000 4000 4000 4000 4000 1500 19,500 Product 3 Rent 1100 2200 2200 2200 2200 1725 11,625 Equity infusion 10711 10,711 Bank loan 36000 36,000 Total Inflows 46711 3600 7700 7700 7700 7700 3850 84,961 Outflows: E-commerce fee 100 200 200 200 200 114 1,014 Packaging Advertising 40 120 120 120 120 35 555 400 400 400 400 400 400 2,400 Fuel 20 20 20 50 50 50 42 252 1000 1000 1000 Manager's salary Loan repayments 1000 1000 1000 1000 1000 1000 1000 10,000 500 500 500 500 500 500 500 500 500 500 500 5,500 Interest payments 120 118 116 114 112 110 108 106 104 118 102 1,228 Car insurance 150 150 150 150 150 150 150 150 150 150 150 150 1,800 Business insurance 200 200 200 200 200 200 200 200 200 200 200 200 2,400 Bank fees 10 10 10 10 10 10 10 10 10 10 10 10 120 Rent 240 240 240 240 240 240 240 240 240 240 240 240 2,880 Website hosting 250 40 290 Investments: Legal fees 2500 2,500 Fixed asset purchases 35000 11526 46,526 Inventory 185 185 Total Outflows 35850 15471 2638 2636 2774 2982 2980 2978 2568 2353 2218 2202 77,650 Net Cash Flow 10861 -15471 -2638 -2636 826 4718 4720 4722 5132 1497 -2218 -2202 7,311 Beginning Cash Ending Cash 10861 -15471 -2638 -2636 826 4718 4720 4722 5132 1497 -2218 -2202 7,311 Ending Cash on this Budget must equal Year 1 cash on the Balance Sheet. Add footer PROJECTED MONTHLY CASH BUDGET FOR BEACH RENTAL CO. - Year 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Sales 2550 2550 7650 7650 7650 7650 2550 $ 38,250 Inflows: Product 1 Rent 500 1500 1500 1500 1500 625 7,125 Product 2 Rent 2000 4000 4000 4000 4000 1500 19,500 Product 3 Rent 1100 2200 2200 2200 2200 1725 11,625 Equity infusion 10711 10,711 Bank loan 36000 36,000 Total Inflows 46711 3600 7700 7700 7700 7700 3850 84,961 Outflows: E-commerce fee 100 200 200 200 200 114 1,014 Packaging Advertising 40 120 120 120 120 35 555 400 400 400 400 400 400 2,400 Fuel 20 20 20 50 50 50 42 252 1000 1000 1000 Manager's salary Loan repayments 1000 1000 1000 1000 1000 1000 1000 10,000 500 500 500 500 500 500 500 500 500 500 500 5,500 Interest payments 120 118 116 114 112 110 108 106 104 118 102 1,228 Car insurance 150 150 150 150 150 150 150 150 150 150 150 150 1,800 Business insurance 200 200 200 200 200 200 200 200 200 200 200 200 2,400 Bank fees 10 10 10 10 10 10 10 10 10 10 10 10 120 Rent 240 240 240 240 240 240 240 240 240 240 240 240 2,880 Website hosting 250 40 290 Investments: Legal fees 2500 2,500 Fixed asset purchases 35000 11526 46,526 Inventory 185 185 Total Outflows 35850 15471 2638 2636 2774 2982 2980 2978 2568 2353 2218 2202 77,650 Net Cash Flow 10861 -15471 -2638 -2636 826 4718 4720 4722 5132 1497 -2218 -2202 7,311 Beginning Cash Ending Cash 10861 -15471 -2638 -2636 826 4718 4720 4722 5132 1497 -2218 -2202 7,311 Ending Cash on this Budget must equal Year 1 cash on the Balance Sheet. Add footer

Answer rating: 100% (QA)

Budgeting is an important technique for businesses to use in order to build financial plans that foresee and plan for earnings and losses over time Companies can use an income statement to do this bas... View the full answer