Question: 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.50 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!