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

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

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
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