Integrative: Pro forma statements 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

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter10: Stockholder's Equity
Section: Chapter Questions
Problem 76E
icon
Related questions
icon
Concept explainers
Topic Video
Question

Integrative: Pro forma statements 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

*Kindly give detailed explanations on how cost of goods sold, operating expenses, accounts receivables, accounts payables, net fixed assets, taxes payable are calculates

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
Financial Statements
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning