ntly operating at full capacity. Required: Prepare Pro-Forma statementsfor 2021(rounding all figures to the nearest dollar) assuming: All costs/income/expenses and net working capital vary directly with sales/revenue. No new equity is raised Sales are projected to increase by 20% The tax rate and the dividend payout ratio will remain constant. Interest Expense will remain unchanged Clearly state if Insignia Corporation Limited will require external financing or would have excess financing in 2021, and how much.

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

Utilize the 2020 financial statements for Insignia Corporation Limited provided and assume that the company is currently operating at full capacity.

Required: Prepare Pro-Forma statementsfor 2021(rounding all figures to the nearest dollar) assuming:

  • All costs/income/expenses and net working capital vary directly with sales/revenue.
  • No new equity is raised
  • Sales are projected to increase by 20%
  • The tax rate and the dividend payout ratio will remain constant.
  • Interest Expense will remain unchanged

Clearly state if Insignia Corporation Limited will require external financing or would have excess financing in 2021, and how much.

Insignia Corporation Limited
Statement of Financial Position
As at December 31, 2018 & 2019
2019
2020
2019
2020
('000s)
('000s)
('000s)
('000s)
ASSETS
LIABILITIES & EQUITY
Current Assets
Current Liabilities
Accounts Payables
Notes Payables
Inventories
350,000
450,000
160,000
175,000
100,000
275,000
Accounts Receivables
200,000
350,000
243,800
395,000
60,000
Cash & Equivalents
220,000
900,000
1088,800
Non-current Liabilites
790,000
835,000
Non Current Assets, Net
700,000
805,000
Total Liabilities
1010,000
1110,000
Equity
Common Stock
Retained Earnings
Total Equity
230,000
260,000
523,800
783,800
360,000
590,000
TOTAL ASSETS
1600,000
1893,800
TOTAL LIAB. & EQUITY
1600,000
1893,800
Transcribed Image Text:Insignia Corporation Limited Statement of Financial Position As at December 31, 2018 & 2019 2019 2020 2019 2020 ('000s) ('000s) ('000s) ('000s) ASSETS LIABILITIES & EQUITY Current Assets Current Liabilities Accounts Payables Notes Payables Inventories 350,000 450,000 160,000 175,000 100,000 275,000 Accounts Receivables 200,000 350,000 243,800 395,000 60,000 Cash & Equivalents 220,000 900,000 1088,800 Non-current Liabilites 790,000 835,000 Non Current Assets, Net 700,000 805,000 Total Liabilities 1010,000 1110,000 Equity Common Stock Retained Earnings Total Equity 230,000 260,000 523,800 783,800 360,000 590,000 TOTAL ASSETS 1600,000 1893,800 TOTAL LIAB. & EQUITY 1600,000 1893,800
Insignia Corporation Limited
Income Statement
For the years ended December 31, 2019 & 2020
2019
2020
('000s)
900,000
(350,000)
(75,000)
(65,000)
(55,000)
355,000
('000s)
Sales
1035,000
Cost of Goods Sold
Selling & Marketing Costs
Admin. Expenses
Depreciation Expense
Earnings before Interest & Taxes
Interest Expense
(400,000)
(80,000)
(75,000)
(60,000)
420,000
(25,000)
330,000
(30,000)
390,000
Taxable Income
Taxation (30%)
(99,000)
231,000
(117,000)
273,000
Net Income
Dividends (40%)
Addition to Retained Earnings
92,400
138,600
109,200
163,800
Transcribed Image Text:Insignia Corporation Limited Income Statement For the years ended December 31, 2019 & 2020 2019 2020 ('000s) 900,000 (350,000) (75,000) (65,000) (55,000) 355,000 ('000s) Sales 1035,000 Cost of Goods Sold Selling & Marketing Costs Admin. Expenses Depreciation Expense Earnings before Interest & Taxes Interest Expense (400,000) (80,000) (75,000) (60,000) 420,000 (25,000) 330,000 (30,000) 390,000 Taxable Income Taxation (30%) (99,000) 231,000 (117,000) 273,000 Net Income Dividends (40%) Addition to Retained Earnings 92,400 138,600 109,200 163,800
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Stock Valuation
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