Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete second half and show excel formulas Input Trek, Inc. Income Statement for 2021 Sales COGS Other expenses Depreciation EBIT Interest Taxable income Taxes (21%)

Complete second half and show excel formulas
 
Input Trek, Inc.

Trek, Inc. Balance Sheet as of December 2021 Calculation 8 Output

Fixed Asset Calculation Full capzcity sales Fixed assets/sales at full capacity Total fixed assets

3 Interest 4 Taxable income Taxes (21%) Net income Dividends Add to RE Trek, Inc. Proforma Balance Sheet begin{tabular}{l}

Trek, Inc. Proforma Balance Sheet Long-term debt Shareholder Equity Common stock Retained earnings Total Equity Total L&E


 
 


Input Trek, Inc. Income Statement for 2021 Sales COGS Other expenses Depreciation EBIT Interest Taxable income Taxes (21%) Net income Dividends Add to RE Current Assets Assets 50,000,000 37,000,000 5,000,000 1,800,000 6,200,000 800,000 5,400,000 1,134,000 4,266,000 1,000,000 3,266,000 Other Inputs Tax rate Growth rate: Capacity Utilization Trek, Inc. Balance Sheet as of December 2021 ACC ADC Liabilities & Equity Current Liabilities Davabla 21% 25% 95% 020.005

Step by Step Solution

3.45 Rating (139 Votes )

There are 3 Steps involved in it

Step: 1

In question 2 We need to estimate the future projection ie called Proforma Balance sheet Of Trek Inc Trek Inc 2021 Proforma Income Statement Sales COG... blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Corporate Finance

Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan

11th edition

77861701, 978-0077861704

More Books

Students also viewed these Accounting questions