Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP. The question is, Include(One) Balance Sheet (Cumulative for all years: Rounds 1 - 6): How would your balance sheet look like after Round

image text in transcribed

PLEASE HELP. The question is, "Include(One) Balance Sheet (Cumulative for all years: Rounds 1 - 6): How would your balance sheet look like after Round 6 finishes?" I already calculated the forecast but don't know where or how to start. We are expected to forecast using just this year. I apologize if I don't have all the necessary information but if you can at least help me with the steps that would be great.

Annual Report Round: 1 Dec. 31, 2022 Erie C131879 2022 Income Statement Echo Edge Egg NA $15,484 $9,423 $12,843 $0 2022 Eat $44,331 Ebb $38,108 NA $0 NA $0 Total $120.189 Common Size 100.0% (Product Name:) Sales Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $0 $14,615 $18,077 $3,284 $35,976 $13,722 $13,553 So $27,275 $3,739 $6,482 $198 $10,419 $5,065 $2,706 54,633 $492 $7,831 $1,593 $3,578 $5,345 $153 $9,075 $3,767 8 6868 $ 50 $0 8 8888 $38,360 $48,090 $4,125 $90,575 31.9% 40.0% 3.4% 75.4% Contribution Margin 38,356 $10,833 $0 $0 $29,614 24.6% Period Costs: Depreciation SC&A R&D Promotions Sales Admin Total Period $3,016 $209 $1.000 $3.000 $447 $7,672 $2,852 SO $1,600 $2,500 $385 $7,337 $720 $172 $0 $0 $156 $1,048 $600 $191 $0 $0 $95 $886 $720 $254 $0 $0 $130 $1,104 8 888888 8 888888 8 888888 $7.908 S826 $2,600 $5,500 $1,213 $18,047 6.6% 0.7% 2.2% 4.6% 1.0% 15.0% 9.6% 0.1% 9.5% 2.4% 4.3% 1.0% 0.0% 1.8% Net Margin $683 $3,497 $4,016 $707 $2,664 $0 $11,567 Definitions: Sales: Unit sales times list price. Direct Labor. Labor costs incurred to produce the product that was sold. Other $140 Inventory Carry Cost the cost to carry unsold goods in inventory. Depreciation: Calculated on straight-line 15-year depreciation of plant value. R&D Costs R&D department expenditures for each product Admin: Administration EBIT $11.427 overhead is estimated at 1.5% of sales. Promotions. The promotion budget for each product. Sales: The sales force Short Term Interest $2,919 budget for each product. Other Chargers and brokerage firms to issue new stocks or bonds plus consulting fees your not included in other categories such as Fees, Write Offs, and TOM. The fees $6 200 Long Term Interest Taxes $1.158 instructor might assess. Write-offs include the loss you might experience when you sell capacity or liquidate inventory as Profit Sharing $43 the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on Net Profit $2,108 the liquidation of capacity or inventory. EBIT. Earrings Before Interest and Taxes. Short Term Interest. Interest expense based on last year's current debt, including short term debt, long term nates that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Variable Margins Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit 2008 Erie C131879 sharing 30.0% 20.0% 10.0% 0.0% Eat Ebb Echo Edge Egg Annual Report Round: 1 Dec. 31, 2022 Erie C131879 2022 Income Statement Echo Edge Egg NA $15,484 $9,423 $12,843 $0 2022 Eat $44,331 Ebb $38,108 NA $0 NA $0 Total $120.189 Common Size 100.0% (Product Name:) Sales Variable Costs: Direct Labor Direct Material Inventory Carry Total Variable $0 $14,615 $18,077 $3,284 $35,976 $13,722 $13,553 So $27,275 $3,739 $6,482 $198 $10,419 $5,065 $2,706 54,633 $492 $7,831 $1,593 $3,578 $5,345 $153 $9,075 $3,767 8 6868 $ 50 $0 8 8888 $38,360 $48,090 $4,125 $90,575 31.9% 40.0% 3.4% 75.4% Contribution Margin 38,356 $10,833 $0 $0 $29,614 24.6% Period Costs: Depreciation SC&A R&D Promotions Sales Admin Total Period $3,016 $209 $1.000 $3.000 $447 $7,672 $2,852 SO $1,600 $2,500 $385 $7,337 $720 $172 $0 $0 $156 $1,048 $600 $191 $0 $0 $95 $886 $720 $254 $0 $0 $130 $1,104 8 888888 8 888888 8 888888 $7.908 S826 $2,600 $5,500 $1,213 $18,047 6.6% 0.7% 2.2% 4.6% 1.0% 15.0% 9.6% 0.1% 9.5% 2.4% 4.3% 1.0% 0.0% 1.8% Net Margin $683 $3,497 $4,016 $707 $2,664 $0 $11,567 Definitions: Sales: Unit sales times list price. Direct Labor. Labor costs incurred to produce the product that was sold. Other $140 Inventory Carry Cost the cost to carry unsold goods in inventory. Depreciation: Calculated on straight-line 15-year depreciation of plant value. R&D Costs R&D department expenditures for each product Admin: Administration EBIT $11.427 overhead is estimated at 1.5% of sales. Promotions. The promotion budget for each product. Sales: The sales force Short Term Interest $2,919 budget for each product. Other Chargers and brokerage firms to issue new stocks or bonds plus consulting fees your not included in other categories such as Fees, Write Offs, and TOM. The fees $6 200 Long Term Interest Taxes $1.158 instructor might assess. Write-offs include the loss you might experience when you sell capacity or liquidate inventory as Profit Sharing $43 the result of eliminating a production line. If the amount appears as a negative amount, then you actually made money on Net Profit $2,108 the liquidation of capacity or inventory. EBIT. Earrings Before Interest and Taxes. Short Term Interest. Interest expense based on last year's current debt, including short term debt, long term nates that have become due, and emergency loans. Long Term Interest: Interest paid on outstanding bonds. Taxes: Income tax based upon a 35% tax rate. Profit Variable Margins Sharing: Profits shared with employees under the labor contract. Net Profit: EBIT minus interest, taxes, and profit 2008 Erie C131879 sharing 30.0% 20.0% 10.0% 0.0% Eat Ebb Echo Edge Egg

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

Equity Valuation And Portfolio Management

Authors: Frank J. Fabozzi, Harry M. Markowitz

1st Edition

047092991X, 9780470929919

More Books

Students also viewed these Finance questions

Question

develop your skills of project planning.

Answered: 1 week ago

Question

evaluate different research strategies;

Answered: 1 week ago