Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. It is January 1st, 2015. 2014 turned out very well for Oscar his projections were quite close. He wants you to project out an

2. It is January 1st, 2015. 2014 turned out very well for Oscar his projections were quite close. He wants you to project out an Income Statement, Balance Sheet and a Cash Flow Statement for 2015 using the new assumptions outlined below. (40 points) a. 2015 year sales will each be 25% higher than the $110,000 realized in 2014 b. Gross margins in 2015 will be 55, 5% higher than the 50% realized in 2014 c. Operating margins will be 22%, 2% higher than 20% realized in 2014 d. Accounts Receivables will be 12% of sales, lower than the 15% seen in 2014 e. Inventory will be 15% of sales, higher than the 12% seen in 2014 f. Accounts Payable will be 4% of sales in 2015, lower than the 5% seen in 2014 g. Accrued expenses payable will be 4% of sales in 2015, lower than the 7% seen in 2014 h. The Bank of Connecticut will continue to be paid 8% interest on the $30,000 worth of loans. i. The combined federal and provincial tax rates will be 30% j. No new capital purchases are made k. Closing cash is expected to remain at the same level predicted for and seen in 2014 l. Depreciation of existing capital equipment continues at the same rate observed in 2014.

Income Statement For the year ended Dec 2014

AmountCalculationsSales100,000 COGS50,000100,000*50%Gross profit50,000100,000*50%Less: operating expenses30,000(50,000-20,000)Operating profit20,000100,000*20%Less: Interest240030,000*8%Profit before tax17600 Less: Taxes 30%528017,600*30%Profit after Taxes1232017600-5280

Balance sheet

AssetAmountCalculationsLiabilityAmountCalculationsCapital equipment35000 Equity Financing28,68083,000-12,320-5,000,7,000,30,000Less: Depreciation3500350,000*10%Profit after taxes12,320 31500 Account payable5,000100,000*5%Cash24,500 Accrued expenses payable7,000100,000*7%Inventory12,0001,000,00*12%Bank Loan30,000 A/R15,0001,000,00*15% Total83,000 Total83,000

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

Crypto Hardware Wallets A Practical Guide For Beginners

Authors: Vincent Bryant

1st Edition

979-8395867742

More Books

Students also viewed these Finance questions

Question

Describe bank payment rules, including posting and settlement.

Answered: 1 week ago