Answered step by step
Verified Expert Solution
Question
1 Approved Answer
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER SALES FORECAST 6,300,000,000 5,321,000,000 4,000,000,000 4,000,000,000 3,100,000,000 3,533,000,000 4,650,000,000 5,000,000,000 4,100,000,000 2,370,000,000 6,900,000,000
JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | ||
SALES FORECAST | 6,300,000,000 | 5,321,000,000 | 4,000,000,000 | 4,000,000,000 | 3,100,000,000 | 3,533,000,000 | 4,650,000,000 | 5,000,000,000 | 4,100,000,000 | 2,370,000,000 | 6,900,000,000 | 7,000,000,000 | |
CASH COLLECTIONS | |||||||||||||
MONTH OF SALE | 20% | 1,260,000,000 | 1,064,200,000 | 800,000,000 | 800,000,000 | 620,000,000 | 706,600,000 | 930,000,000 | 1,000,000,000 | 820,000,000 | 474,000,000 | 1,380,000,000 | 1,400,000,000 |
FIRST MONTH AFTER SALE | 50% | 3,150,000,000 | 2,660,500,000 | 2,000,000,000 | 2,000,000,000 | 1,550,000,000 | 1,766,500,000 | 2,325,000,000 | 2,500,000,000 | 2,050,000,000 | 1,185,000,000 | 3,450,000,000 | |
SECOND MONTH AFTER SALE | 30% | 1,890,000,000 | 1,596,300,000 | 1,200,000,000 | 1,200,000,000 | 930,000,000 | 1,059,900,000 | 1,395,000,000 | 1,500,000,000 | 1,230,000,000 | 711,000,000 | ||
TOTAL CASH INFLOWS | $ 1,260,000,000 | $ 4,214,200,000 | $ 5,350,500,000 | $4,396,300,000 | $3,820,000,000 | $3,456,600,000 | $3,626,500,000 | $4,384,900,000 | $ 4,715,000,000 | $4,024,000,000 | $3,795,000,000 | $5,561,000,000 | |
JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | ||
DIRECT MANUFACTURING COSTS | - | - | - | ||||||||||
INSURANCE | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | 10,000,000 | |
PAYROLL | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | 26,666,667 | |
TECHNOLOGY | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | 3,561,666,667 | |
ADVERTISEMENT | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | 12,500,000 | |
VIDEO AND MUSIC | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | 916,666,667 | |
TAXES | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | 200,000,000 | |
COVID RELATED EXPENSES | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | 416,666,667 | |
TOTAL CASH OUTFLOWS | $ 5,144,166,668 | $ 5,144,166,668 | $ 5,144,166,668 | $5,144,166,668 | $5,144,166,668 | $5,144,166,668 | $5,144,166,668 | $5,144,166,668 | $ 5,144,166,668 | $5,144,166,668 | $5,144,166,668 | $5,144,166,668 | |
5,144,166,668 | |||||||||||||
MONTHLY NET CASH GAIN OR LOSS | $ (3,884,166,668) | $ (929,966,668) | $ 206,333,332 | $ (747,866,668) | $ (1,324,166,668) | $ (1,687,566,668) | $ (1,517,666,668) | $ (759,266,668) | $ (429,166,668) | $ (1,120,166,668) | $ (1,349,166,668) | $ 416,833,332 | |
JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | ||
CASH FLOW SUMMARY | |||||||||||||
1. Cash balance at start of month | |||||||||||||
2. Net cash gain (loss) during month | |||||||||||||
3. Cash bal. at end of month (before financing) | |||||||||||||
4. Minimum cash balance desired | |||||||||||||
5. Surplus cash (OR) Deficit cash (Line 3 - Line 4) | |||||||||||||
EXTERNAL FINANCING SUMMARY | |||||||||||||
6. External financing balance - start of month | |||||||||||||
7. New financing reqd (negative of Line 5) (if deficit!) | |||||||||||||
8. Financing repayments (if surplus!) | |||||||||||||
9. Ext financing balance - end of month | |||||||||||||
10.Cash bal at end of mo (Line3 + Line7 + Line8) |
How do I calculate the cash flow summary and the external financing summary with the information I provided? How do I calculate a 4-Year Profit and Loss Projection (36.00% per annum) Growth estimate and a Projected Balance Sheet, Income statement for the Next 3 Years. I am really stuck! Thank you
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