Morten Metal Limited has assembled past (2020) financial statements (income statement and balance sheet follows) and financial projections for use in preparing financial plans for the coming year (2021). Information related to financial projections for the year 2021 follows.  (1) Projected sales are $420,000. (2) Cost of goods sold in 2020 includes $72,000 in fixed costs. (3) Operating expense in 2020 includes $17,500 in fixed costs. (4) Interest expense will be $18,000 in 2021. (5) The firm will pay cash dividend amounting to 25% of net profit after taxes. (6) Cash and inventories are expected to double. (7) Marketable securities, long-term debt, and common stock will remain unchanged. (8) Accounts receivable, accounts payable, and other current liabilities will change in  direct response to the change in sales. (9) During the year, the firm will purchase a delivery vehicle costing $25,000. The  depreciation expense on the new vehicle for 2021 will be $7,000. (10) The tax rate will remain at 25%.  a. Prepare a pro forma income statement for the year ended December 31, 2021, using the fixed cost data given to improve the accuracy of percent-of-sales method. b. Prepare a pro forma balance sheet as of December 31, 2021, using the information provided and the judgmental approach. Include a reconciliation of retained earnings account. c. Analyze these statements, and discuss the resulting external financing required

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Morten Metal Limited has assembled past (2020) financial statements (income statement and balance sheet follows) and financial projections for use in preparing financial plans for the coming year (2021).

Information related to financial projections for the year 2021 follows. 
(1) Projected sales are $420,000.
(2) Cost of goods sold in 2020 includes $72,000 in fixed costs.
(3) Operating expense in 2020 includes $17,500 in fixed costs.
(4) Interest expense will be $18,000 in 2021.
(5) The firm will pay cash dividend amounting to 25% of net profit after taxes.
(6) Cash and inventories are expected to double.
(7) Marketable securities, long-term debt, and common stock will remain unchanged.
(8) Accounts receivable, accounts payable, and other current liabilities will change in 
direct response to the change in sales.
(9) During the year, the firm will purchase a delivery vehicle costing $25,000. The 
depreciation expense on the new vehicle for 2021 will be $7,000.
(10) The tax rate will remain at 25%. 
a. Prepare a pro forma income statement for the year ended December 31, 2021, using the fixed cost data given to improve the accuracy of percent-of-sales method.
b. Prepare a pro forma balance sheet as of December 31, 2021, using the information provided and the judgmental approach. Include a reconciliation of retained earnings account.
c. Analyze these statements, and discuss the resulting external financing required

Morten Metal Ltd. Income Statement for Year
Ended December 31, 2020
Sales revenue
$350,000
Less: Cost of goods sold
192,500
Gross profits
$157,500
Less: Operating expenses
59,500
Operating profits
$ 98,000
Less: Interest expense
14,000
Net profits before taxes
$ 84,000
Less: Taxes (rate = 25%)
21,000
Net profits after taxes
$ 63,000
Less: Cash dividends
20,000
To retained earnings
$ 43,000
Transcribed Image Text:Morten Metal Ltd. Income Statement for Year Ended December 31, 2020 Sales revenue $350,000 Less: Cost of goods sold 192,500 Gross profits $157,500 Less: Operating expenses 59,500 Operating profits $ 98,000 Less: Interest expense 14,000 Net profits before taxes $ 84,000 Less: Taxes (rate = 25%) 21,000 Net profits after taxes $ 63,000 Less: Cash dividends 20,000 To retained earnings $ 43,000
Morten Metal Limited Balance Sheet on December 31, 2020
Assets
Liabilities and stockholders' equity
Cash
$ 16,200
Accounts payable
$ 50,000
Marketable securities
15,500
Taxes payable
6,600
Accounts receivable
43,700
Other current liabilitics
13,800
$ 70,400
Inventories
35,000
Total current liabilities
Total current assets
$110,400
Long-term debt
36,000
Net fixed assets
112,000
Total liabilities
$106,400
Total assets
$222,400
Common stock
52,000
Retained earnings
64,000
Total liabilities and equity
$222,400
Transcribed Image Text:Morten Metal Limited Balance Sheet on December 31, 2020 Assets Liabilities and stockholders' equity Cash $ 16,200 Accounts payable $ 50,000 Marketable securities 15,500 Taxes payable 6,600 Accounts receivable 43,700 Other current liabilitics 13,800 $ 70,400 Inventories 35,000 Total current liabilities Total current assets $110,400 Long-term debt 36,000 Net fixed assets 112,000 Total liabilities $106,400 Total assets $222,400 Common stock 52,000 Retained earnings 64,000 Total liabilities and equity $222,400
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Forecasting Financial Statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education