Supposed you were hired by

1 Input 2 Trek, Inc. 3 Income Statement for 2020 4 Sales 6,700,000 5 COGS 3,300,000 6 Other expenses 500,000 7 Depreciation 1,800,000 8 EBIT Other Inputs 9 Interest 800,000 Tax rate 21% 10 Taxable income Growth rate 25% 11 Taxes (21%) Capacity Utilization 90% 12 Net income 13 14 Dividends 100,000 15 Add to RE 16 17 Trek, Inc. 18 Balance Sheet as of December 2020 19 Assets Liabilities & Equity 20 Current Assets Current Liabilities 21 Cash 45,000 Accounts Payable 90,000 22 Accounts rec. 75,000 Notes Payable 210,000 23 Inventory 130,000 Total CL 24 Total CA 25 Long-term debt 1,250,000 26 27 Shareholder Equity Task 1-Financial Planning Task 2- Time value of money Task 3-DCF Task 4-Loan amortization Task 5-Bond +