Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Learning objective: Apply the percent of sales method to creating pro forma income statement and balance sheet. The first step in to express the balance

Learning objective: Apply the percent of sales method to creating pro forma income statement and balance sheet.

  • The first step in to express the balance of an accounting item in the income statement or balance sheet as a percent of current sales revenue. Then multiply that percentage by the projected sales revenue to arrive the projected amount for an accounting item in the coming year. For example, IMCs costs except depreciation were $56,800, which accounted for 94.67% of current years sales revenue ($56,800/$60,000 = 94.67%). The projected costs except depreciation for the upcoming year will be 94.67% x $75,000 (the projected sales revenue) = $71,000.

  • Some of the accounting items expressed as a percentage of sales are meaningless. This is because either the balance of the accounting item remains unchanged or its proportional change does not correspond to the percentage change in sales. We put a n.a. in the percentage column.

  • We assume that IMC dividend payout ratio remains unchanged for the coming year. Given the $117 dividends and net income of $390 from the income statement, we know that its dividend payout ratio is cash dividend / net income = $117/$390 = 30%. This implies that IMCs retention ratio is 70%, as the sum of the dividend payout and retention ratios equals to 100%.

  • The textbook provides the formula for the projected retained earnings. The projected retained earnings

    = The retained earnings from the past year + projected net income projected cash dividends to be paid

    Therefore, you will use the dividend payout ratio in the calculations.

  • You will find that the pro forma balance sheet is imbalanced as total assets are not equal to total

    liabilities and stockholders equity. If the projected total assets exceed projected total liabilities and stockholders equity, this indicates that external financing is needed. Please compute the needed amount from external financing.

    Explanations for each item have been inserted as notes in the Excel file.

  • image text in transcribed

image text in transcribed

International Motor Corporation Income Statement (in millions) For the year of 2019 International Motor Corporation Proforma Income Statement (in millions) For the year of 2020 Percentage of Sales $ $ $ 5 Sales 6 Costs except depreciation 7 EBITDA 8 Depreciation 9 EBIT 10 Interest expense 11 Pretax income 12 Income taxes (35%) 13 Net income 14 Dividends Addition to retained earnings 60,000.00 56,800.00 3,200.00 1,200.00 2,000.00 1,400.00 600.00 210.00 390.00 Sales Costs except depreciation EBITDA Depreciation EBIT Interest expense Pretax income Income taxes (35%) Net income $ n.a. $1,400.00 n.a. ina n.a. n.a. 117.00 273.00 15 International Motor Corporation Balance Sheet (in millions) As of 12/31/2019 Liabilities and Stockholders' Equity 4 Assets Sales in 2019 60,000 Percentage of Sales Percentage of Sales $3,080 2,800 6,200 $12,080 $6,400 $3,980 $10,380 $6,500 6 Current assets 7 Cash Accounts receivable 9 Inventory 10 Total 11 Fixed assets 12 Net plant and equipment 13 14 15 Total assets Current liabilities Accounts payable Notes payable Total Long-term debt Stockholders' equity Common stock and paid-in surplus Retained earnings Total Total liabilities and stockholders' equity $ 23,087 $2,735 15,552 $18,287 $35,167 $35,167 na. n.a. 16 17 18 19 International Motor Corporation Pro Forma Balance Sheet (in millions) Liabilities and Stockholders' Equity Projected sales in 2020 $0! 22 Assets 23 24 Current assets 25 Cash 26 Accounts receivable 27 Inventory 28 Total 29 Fixed assets 30 Net plant and equipment Current liabilities Accounts payable Notes payable Total Long-term debt Stockholders' equity Common stock and paid-in surplus Retained carnings 31 32 Total 33 Total assets Total liabilities and stockholders' equity 34 External financing needed 35 36 37 39 International Motor Corporation Income Statement (in millions) For the year of 2019 International Motor Corporation Proforma Income Statement (in millions) For the year of 2020 Percentage of Sales $ $ $ 5 Sales 6 Costs except depreciation 7 EBITDA 8 Depreciation 9 EBIT 10 Interest expense 11 Pretax income 12 Income taxes (35%) 13 Net income 14 Dividends Addition to retained earnings 60,000.00 56,800.00 3,200.00 1,200.00 2,000.00 1,400.00 600.00 210.00 390.00 Sales Costs except depreciation EBITDA Depreciation EBIT Interest expense Pretax income Income taxes (35%) Net income $ n.a. $1,400.00 n.a. ina n.a. n.a. 117.00 273.00 15 International Motor Corporation Balance Sheet (in millions) As of 12/31/2019 Liabilities and Stockholders' Equity 4 Assets Sales in 2019 60,000 Percentage of Sales Percentage of Sales $3,080 2,800 6,200 $12,080 $6,400 $3,980 $10,380 $6,500 6 Current assets 7 Cash Accounts receivable 9 Inventory 10 Total 11 Fixed assets 12 Net plant and equipment 13 14 15 Total assets Current liabilities Accounts payable Notes payable Total Long-term debt Stockholders' equity Common stock and paid-in surplus Retained earnings Total Total liabilities and stockholders' equity $ 23,087 $2,735 15,552 $18,287 $35,167 $35,167 na. n.a. 16 17 18 19 International Motor Corporation Pro Forma Balance Sheet (in millions) Liabilities and Stockholders' Equity Projected sales in 2020 $0! 22 Assets 23 24 Current assets 25 Cash 26 Accounts receivable 27 Inventory 28 Total 29 Fixed assets 30 Net plant and equipment Current liabilities Accounts payable Notes payable Total Long-term debt Stockholders' equity Common stock and paid-in surplus Retained carnings 31 32 Total 33 Total assets Total liabilities and stockholders' equity 34 External financing needed 35 36 37 39

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

Exploring Public Relations And Management Communication

Authors: Ralph Tench, Stephen Waddington

5th Edition

1292321741, 9781292321745

More Books

Students also viewed these Finance questions

Question

Who will implement and maintain the project after launch?

Answered: 1 week ago

Question

analyze aesthetic enhancing design rules.

Answered: 1 week ago

Question

apply communication design concepts into creative projects.

Answered: 1 week ago