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

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter11: The Statement Of Cash Flows
Section: Chapter Questions
Problem 66.5C: Comparative Analysis: Under Armour, Inc., versus Columbia Sportswear Refer to the 10-K reports of...
icon
Related questions
Question

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            

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Balance Sheet Analysis
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
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning