Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Larime Corp. is forecasting 20X2 near the end of 20X1. The estimated year-end financial statements and a worksheet for the forecast are given below. Management

Larime Corp. is forecasting 20X2 near the end of 20X1. The estimated year-end financial statements and a worksheet for the forecast are given below. Management expects the following next year. An 7% increase in revenue. Price cutting will cause the cost ratio (COGS/sales) to deteriorate (increase) by 1% (of sales) from its current level. Expenses will increase at a rate that is three quarters of that of sales. The current accounts will increase proportionately with sales. Net fixed assets will increase by $6 million. All interest will be paid at 12%. Federal and state income taxes will be paid at a combined rate of 43%. Make a forecast of Larime's complete income statement and balance sheet. Enter your dollar answers in thousands. For example, an answer of $12 thousands should be entered as 12, not 12,000. Round percentage values to 1 decimal place. Enter all amounts as a positive numbers.

image text in transcribed

I cant figure out where i went wrong? so some help would be great

Larime Corp. Projected Income Statement ($000) 20X1 20x2 0% % Revenue $255,746 $ 100.0 100.0 57.7 273,648 160,631 COGS 147,546 58.7 41.3 Gross Margin $ 108,200 42.3 113,017 Expenses 45,784 17.9 48,188 17.6 EBIT $62,416 24.4 $ 64,829 Interest (12%) 9,577 3.7 9,577 ) 23.7 3.5 x 20.2 X EBT $52,839 20.7 $ 55,252 x [ Inc Tax (43%) 22,721 8.9 23,758 8.7 X Net Income $30,118 11.8 $ 31,494 x 11.5 x C/A Larime Corp. Projected Balance Sheet ($000) ASSETS LIABILITIES & EQUITY 20X1 20X2 20X1 20X2 $178,940 $ 191,466 C/L $83,487 $ 89,331 140,648 146,648 Debt 79,450 179,450 $319,588 $ 338,114 Equity 156,651 169,333 F/A Total Total $319,588 $ 338,114

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_2

Step: 3

blur-text-image_3

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

Sound Investing Uncover Fraud And Protect Your Portfolio

Authors: Kate Mooney

1st Edition

0071481826, 9780071481823

More Books

Students also viewed these Accounting questions

Question

Let X have binomial distribution 12, 0.25). Find X 5).

Answered: 1 week ago