Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Sustainability

Authors: Gunnar Rimmel

1st Edition

0367478927, 9780367478926

More Books

Students also viewed these Accounting questions