From the balance sheet prepare a proforma income statement where revenues can increase by 2% and the firm can borrow at 5.5% BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other CA 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciations 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Pro-forma statement Pro Forma Forecasts Actual Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 COGS/REVENUES SGA/SALES INVENTORIES/COGS OTHER CA/SALES AR/SALES AP/COGS SALES/FIXED ASSETS DEPR/ FIXED ASSETS EQUITY/INVESTED CAPITAL ST DEBT/INVESTED CAPITAL LT DEBT/INVESTED CAPITAL TAX RATE DEPRECIATION / FIXED ASSETS Revenue growth rate
From the balance sheet prepare a proforma income statement where revenues can increase by 2% and the firm can borrow at 5.5% BALANCE SHEET 2021 Cash and cash equivalents 280 Receivables 2588 Inventory 2516 Other CA 189 TOTAL CA 5573 Fixed assets 5024 TOTAL ASSETS 10597 Accounts payable 4713 Short term debt 78 TOTAL CL 4790 LT debt 921 Shareh. Equity 4886 TOTAL LIAB. AND SHARH. EQUITY 10597 INCOME STATEMENT 2021 Sales 19418 COGS 13136 Depreciations 354 SG&A 4952 EBIT 976 Interest Expenses 52 Tax 268 Net income 656 Pro-forma statement Pro Forma Forecasts Actual Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 COGS/REVENUES SGA/SALES INVENTORIES/COGS OTHER CA/SALES AR/SALES AP/COGS SALES/FIXED ASSETS DEPR/ FIXED ASSETS EQUITY/INVESTED CAPITAL ST DEBT/INVESTED CAPITAL LT DEBT/INVESTED CAPITAL TAX RATE DEPRECIATION / FIXED ASSETS Revenue growth rate
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
From the
BALANCE SHEET | 2021 |
Cash and cash equivalents | 280 |
Receivables | 2588 |
Inventory | 2516 |
Other CA | 189 |
TOTAL CA | 5573 |
Fixed assets | 5024 |
TOTAL ASSETS | 10597 |
Accounts payable | 4713 |
Short term debt | 78 |
TOTAL CL | 4790 |
LT debt | 921 |
Shareh. Equity | 4886 |
TOTAL LIAB. AND SHARH. EQUITY | 10597 |
INCOME STATEMENT | 2021 |
Sales | 19418 |
COGS | 13136 |
354 | |
SG&A | 4952 |
EBIT | 976 |
Interest Expenses | 52 |
Tax | 268 |
Net income | 656 |
Pro-forma statement
Pro Forma |
Actual | Projected | Projected | Projected | Projected | Projected |
2021 | 2022 | 2023 | 2024 | 2025 | 2026 | |
COGS/REVENUES | ||||||
SGA/SALES | ||||||
INVENTORIES/COGS | ||||||
OTHER CA/SALES | ||||||
AP/COGS | ||||||
SALES/FIXED ASSETS | ||||||
DEPR/ FIXED ASSETS | ||||||
EQUITY/INVESTED CAPITAL | ||||||
ST DEBT/INVESTED CAPITAL | ||||||
LT DEBT/INVESTED CAPITAL | ||||||
TAX RATE | ||||||
DEPRECIATION / FIXED ASSETS | ||||||
Revenue growth rate |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
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.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education