Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare a Pro Forma (projected) income statement for Toy World for 1994 assuming they adopt the new level production strategy. Please use the same format

  1. Prepare a Pro Forma (projected) income statement for Toy World for 1994 assuming they adopt the new level production strategy. Please use the same format as Toy World used for its original 1994 Pro Forma Income Statement that employed their seasonal production strategy. Project the approximate balance sheet balances Toy World would have in their Cash, Accounts Receivable, Inventory and Notes Payable, Bank accounts if they employed the new level production strategy. Do not consider any changes to other balance sheet accounts that may occur as they will all be relatively immaterial (for example, the Accrued Taxes balance would change since Toy Worlds earnings would change, but the amount is relatively small). HINT Accounts Receivable should not change between the 2 options, but will need to be factored in to correctly project the other items (cash, inventory, notes payable).
FG FG FG FG
Month Completed COGS Net Change Beg End
January $ 542,500 $ 78,000 $ 464,500 $ 586,000 $ 1,050,500
February $ 542,500 $ 91,000 $ 451,500 $ 1,050,500 $ 1,502,000
March $ 542,500 $ 104,000 $ 438,500 $ 1,502,000 $ 1,940,500
April $ 542,500 $ 91,000 $ 451,500 $ 1,940,500 $ 2,392,000
May $ 542,500 $ 91,000 $ 451,500 $ 2,392,000 $ 2,843,500
June $ 542,500 $ 91,000 $ 451,500 $ 2,843,500 $ 3,295,000
July
August
September
October
November
December
Cash/Notes Payable Budget
Projected 1994 - Level Production
($000's)
Jan Feb March April May June July Aug Sept Oct Nov Dec
Inflows:
A/R Collection (Sales from 2 months ago) $ 1,965 $ 940 $ 120 $ 140 $ 160 $ 140
Interest Income $ 1 $ 2 $ 1 $ 1 $ 1 $ 1
Total $ 1,966 $ 942 $ 121 $ 141 $ 161 $ 141
Outflows:
Payments of A/P $ 282 $ 250 $ 250 $ 250 $ 250 $ 250
Operating Expenses (Assumes paid when incurred)* $ 205 $ 207 $ 209 $ 211 $ 213 $ 215
Wages ($3,510/12) $ 293 $ 292 $ 293 $ 292 $ 293 $ 292
Interest Expense $ 7 $ 4 $ 4 $ 7 $ 12 $ 17
Total $ 787 $ 753 $ 756 $ 760 $ 768 $ 774
Net Inflow/(Outflow)
Beginning Cash $ 200 $ 627 $ 816 $ 200 $ 200 $ 200
Ending Cash Before Loan Increase/(Repayment) $ 1,379 $ 816 $ 181 $ (419) $ (407) $ (433)
Desired Cash Balance $ 200 $ 200 $ 200 $ 200 $ 200 $ 200
Loan Increase/(Repayment) $ (752) $ - $ 19 $ 619 $ 607 $ 633
End of Month Loan $ - $ - $ 19 $ 638 $ 1,245 $ 1,878
End of Month Cash $ 627 $ 816 $ 200 $ 200 $ 200 $ 200
*Additional Inventory/Storage Costs are prorated based on projected inventory balances by month.

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

Understanding Letter Of Credit Learners Guide To Letter Of Credit

Authors: Nisha S Koshal

1946822078, 978-1946822079

More Books

Students also viewed these Accounting questions

Question

fscanf retums a special value EOF that stands for...

Answered: 1 week ago

Question

What does the start( ) method defined by Thread do?

Answered: 1 week ago

Question

4. Describe cultural differences that influence perception

Answered: 1 week ago