Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help for a Global Business class I have provided a Projected 10-Year Cash Flow Analysis, please pick at least 1 parameter (e.g., volume, price,
Need help for a Global Business class
I have provided a Projected 10-Year Cash Flow Analysis, please pick at least 1 parameter (e.g., volume, price, etc.) and show a sensitivity analysis according to the cash flow analysis provided
Cash Flow Year 2 Year 3 Year 4 Year 5 Year 6 Year Year 8 Year 9 Year 10 Year 1 CASH RECEIPTS $220p00 $330,000 Cash Sales $807,840 $1,211,760 $1,223,878 $2,080,592 $2,704,769 $4,057,154 S561,000 S673,200 Direct Cost of sales S77000 S115500 S196350 S235620 S282744 S424116 S428 357 S728 207 S946 669 $1,420,004 Total Cash from Sales $143,000 $214,500 S364,650 S437,580 S525,096 $787,644 S795,520 s1.352,385 s1,758,100 s2,637,150 000 Cash disbursements Security Deposit S100,00 so S100,000 S0 sol S100,000 sol S200,000 S200,000 sz50,000 Payroll S60,000 S72.000 IS93600 S93 600 S100,000 S130,000 S130,000 S170,000 S170,000 20,000 payroll taxes $6000 st.200 $9360 S9360 S10,000 13,000 000 $17000 $17000 $2,000 Rent S12000 S12,000 12.000 S12000 S12000 S12000 $24,000 24,000 24,000 24,000 Boat Maintenance supplies S2500 2500 S5000 S5.000 S10,000 sz5.000 25.000 S50,000 S50,000 75.000 Loan payments $0 $25.000 S25.000 S50,000 50,00 S0 S0 S0 Marketing $5.000 $5.000 $5000 S5.000 S5.000 $15.000 5.000 ES25000 25.000 25.000 Utilities 500 S500 S500 S500 $500 S500 si 5.000 5000 S15000 5000 20,00 $10,000 20,000 50,000 50,000 20,000 50,000 Total operating Expenses S196.000 S134200 S270460 S195460 S207500 S315 500 S242,000 51,000 S551.000 1.000 EBIT S92,000 S80 300 IS94 190 S242 120 S31,596 S472144 S553 520 S801 385 S1 207100 S2176150 Taxes Total cash disbursements 31,400 $163,540 $302,917 S61733 S167384 S220,217 Net cash flow $61,600 $50,960 $330,501 $387,464 $560,969 $844,970 $1,523,305 Cash Receipts S293000 S214 500 S364 650 SA37 580 S525.0961 7,644 $795,520 $1,3 385 $1.758100 S2,637150 352 31,400 $163,540 S302,917 $791,415 $913,130 $1,113,845 s61,600 S112,560 174,293 s341,677 S561,894 $892,395 s1.279,859 $1,840,829 $2,685,799 S4209,104 Ending Cash balance Cash Flow Year 2 Year 3 Year 4 Year 5 Year 6 Year Year 8 Year 9 Year 10 Year 1 CASH RECEIPTS $220p00 $330,000 Cash Sales $807,840 $1,211,760 $1,223,878 $2,080,592 $2,704,769 $4,057,154 S561,000 S673,200 Direct Cost of sales S77000 S115500 S196350 S235620 S282744 S424116 S428 357 S728 207 S946 669 $1,420,004 Total Cash from Sales $143,000 $214,500 S364,650 S437,580 S525,096 $787,644 S795,520 s1.352,385 s1,758,100 s2,637,150 000 Cash disbursements Security Deposit S100,00 so S100,000 S0 sol S100,000 sol S200,000 S200,000 sz50,000 Payroll S60,000 S72.000 IS93600 S93 600 S100,000 S130,000 S130,000 S170,000 S170,000 20,000 payroll taxes $6000 st.200 $9360 S9360 S10,000 13,000 000 $17000 $17000 $2,000 Rent S12000 S12,000 12.000 S12000 S12000 S12000 $24,000 24,000 24,000 24,000 Boat Maintenance supplies S2500 2500 S5000 S5.000 S10,000 sz5.000 25.000 S50,000 S50,000 75.000 Loan payments $0 $25.000 S25.000 S50,000 50,00 S0 S0 S0 Marketing $5.000 $5.000 $5000 S5.000 S5.000 $15.000 5.000 ES25000 25.000 25.000 Utilities 500 S500 S500 S500 $500 S500 si 5.000 5000 S15000 5000 20,00 $10,000 20,000 50,000 50,000 20,000 50,000 Total operating Expenses S196.000 S134200 S270460 S195460 S207500 S315 500 S242,000 51,000 S551.000 1.000 EBIT S92,000 S80 300 IS94 190 S242 120 S31,596 S472144 S553 520 S801 385 S1 207100 S2176150 Taxes Total cash disbursements 31,400 $163,540 $302,917 S61733 S167384 S220,217 Net cash flow $61,600 $50,960 $330,501 $387,464 $560,969 $844,970 $1,523,305 Cash Receipts S293000 S214 500 S364 650 SA37 580 S525.0961 7,644 $795,520 $1,3 385 $1.758100 S2,637150 352 31,400 $163,540 S302,917 $791,415 $913,130 $1,113,845 s61,600 S112,560 174,293 s341,677 S561,894 $892,395 s1.279,859 $1,840,829 $2,685,799 S4209,104 Ending Cash balance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started