Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show details PLZ Harrison Inc. wants to create forecasted financial statements for 2019 based on its accounting data in 2018. In 2018 total revenue was

Show details PLZ

image text in transcribed

Harrison Inc. wants to create forecasted financial statements for 2019 based on its accounting data in 2018. In 2018 total revenue was $1,350,000; cost of goods sold was $ 1,180,000; selling and G&A expenses were $ 120,000; depreciation expense was $18,900; interest expense was $23,250; the average tax rate was 40%, and the number of shares outstanding was 90,000. Also, in 2018 Harrison had cash of $25,500; accounts receivable of $135,000; inventory of $210,000; plant & equipment of $1,270,000 with an accumulated depreciation of $275,000. Accounts payable, notes payable, long-term debt, common stock, additional paid-in-capital, and retained earnings represented 8%, 0.8%, 21%, 43.5%, 11.7%, and 15% of total assets, respectively. For 2019, Harrison Inc expects a 23% increase in total revenue, while cost of goods sold and selling and G&A expenses are expected to remain at the same proportion of total revenue as in 2018. Both total plant and equipment and depreciation expense will increase by 10%. Similarly, long-term debt is forecasted, and interest expense will increase by 18%, but the tax rate and the number of shares outstanding will remain constant. Additionally accounts receivable, inventory are expected to increase 16%. Accounts payable and notes payable are expected to increase 17%, while common stock and paid-in-capital will increase by 25%. The dividend policy in 2019 will be based on a dividend payout ratio of 50%. In other words, 50% of forecasted earnings will be paid to shareholders as dividends. Using these projections, create the forecasted 2019 income statement, balance sheet, and statement of cash flows for Harrison Inc. Create an input section in your income statement and balance sheet towards the top of the sheet. Put the percentages in these input cells. Then refer to those input cells in your formulas. Each statement should be on a separate worksheet

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

Handbook Of The Economics Of Finance

Authors: George M. Constantinides, Milton Harris, Rene M. Stulz

1st Edition

044459406X, 978-0444594068

More Books

Students also viewed these Finance questions

Question

What is the environment we are trying to create?

Answered: 1 week ago

Question

How can we visually describe our goals?

Answered: 1 week ago