Can someone please fill these pages out with formulas

Your Company Name Balance Sheet For Years Ending X0 - X5 X0 X1 X2 X3 X4 X5 Assets Cash Marketable Securities Accounts Receivable Inventory Other Assets Total Current Assets 0% 0 0% 0 0% 0 0% 0 Property Plant Equipment Accumulated Depreciation Total Fixed Assets Total Assets Liabilities and Equity Accounts Payable Notes Payable Other Current Liabilities Total Current Liabilities Mortgages Other Non-Current Liabilities Total Non-Current Liabilities Total Liabilities 0% - Common Stock Paid in Capital Treasury Stock Retained Earnings Total Equity Total Liabilities and Equity ACCT 522 KAREEM TANNOUS DR. BOYLAN Your Company Name Income Statement For Years Ending X0 - X5 X0 X1 X2 Sales Cost of Goods Sold Gross Profit Interest Revenue - Corp Bonds Net Income From Operations Depreciation Expense Salaries Expense Interest Expense Miscellaneous Expense Operating Expenses Net Income Before Tax Taxes Interest Revenue - Muni Bonds Net Income ACCT 522 KAREEM TANNOUS X3 X4 X5 0% 0 0% 0 DR. BOYLAN Your Company Name Statement of Retained Earnings For Years Ending X0 - X5 X0 X1 X2 X3 X4 X5 Retained earnings, January 1 Add: Net Income Less: Dividends Retained Earnings, December 31 ACCT 522 KAREEM TANNOUS DR. BOYLAN Your Company Name Cash Flow Statement Cash Flow from Operations Net Income Depreciation Expense Increase in Accounts Receivable Increase in Accounts Payable Increase in Inventories Marketable Securities Other Assests Other Liabilities Net Operating Cash For Years Ending X0 - X5 X0 X1 X2 X3 X4 X5 Cash Flow from Investing Equipment Purchase Land Purchase Net Investing Cash Cash Flow from Financing Issuance of Mortgage Dividend Payments Net Financing Cash Free Cash Flow ACCT 522 KAREEM TANNOUS DR. BOYLAN Your Company Name Revenue For Years Ending X0 - X5 X0 X1 X2 X3 Price Quanity Sales ACCT 522 X4 X5 0% 0% KAREEM TANNOUS 0 0 DR. BOYLAN Your Company Name FIFO Inventory For Years Ending X0 - X5 X0 X1 X2 X3 X4 X5 Cost Quanity Total Merchandise 0.0% 0% Year X1 X2 X3 X4 X5 ACCT 522 Purchases BB Units Volume Units Volume Units Volume Units Volume Units Volume $ $ - COGS - $ - $ - $ - $ - $ - - $ - $ - $ - - $ - - $ EB $ $ - $ - $ - $ - $ - $ KAREEM TANNOUS 0 0 - $ - DR. BOYLAN Your Company Name Depreciation for Equipment and Plant For Years Ending X0 - X5 Equipment Cost of Equipment Estimated Useful Life Estimated Salvage Value Depreciation per year Plant Cost of Plant Estimated Useful Life Estimated Salvage Value Depreciation per year Total Depreciation per Year $ #DIV/0! $ #DIV/0! ACCT 522 0 #DIV/0! X0 Yearly Equipment Depreciation Yearly Plant Depreciation Total Accumulated Depreciation 0 200,000 X1 #DIV/0! #DIV/0! #DIV/0! KAREEM TANNOUS X2 #DIV/0! #DIV/0! #DIV/0! X3 #DIV/0! #DIV/0! #DIV/0! X4 #DIV/0! #DIV/0! #DIV/0! X5 #DIV/0! #DIV/0! #DIV/0! DR. BOYLAN Your Company Name Taxable Income Worksheet For Years Ending X0 - X5 Tax Calculation Yr 1 Taxable Income Over Not Over 50,000 50,000 75,000 75,000 100,000 100,000 335,000 335,000 10,000,000 10,000,000 15,000,000 15,000,000 18,333,333 18,333,333 + Income $ Rate Taxable Inc 15% 25% 34% 39% 34% 35% 38% 35% - - Total Tax Total Tax $ - Tax Calculation Yr 2 Taxable Income Over Not Over 100,000 150,000 100,000 125,000 125,000 150,000 570,000 805,000 19,665,000 29,330,000 20,000,000 25,000,000 21,666,666 24,999,999 18,333,333 + Income $ - Rate Taxable Inc 15% 25% 34% 39% 34% 35% 38% 35% Total Tax Total Tax - $ Tax Calculation Yr 3 Taxable Income Over Not Over 100,000 150,000 100,000 125,000 125,000 150,000 570,000 805,000 19,665,000 29,330,000 20,000,000 25,000,000 21,666,666 24,999,999 18,333,333 + Income $ - Rate Taxable Inc 15% 25% 34% 39% 34% 35% 38% 35% Total Tax Total Tax - $ Tax Calculation Yr 4 Taxable Income Over Not Over 200,000 250,000 150,000 175,000 175,000 200,000 1,040,000 1,275,000 38,995,000 48,660,000 30,000,000 35,000,000 28,333,332 31,666,665 18,333,333 + Income $ - Rate Taxable Inc 15% 25% 34% 39% 34% 35% 38% 35% Total Tax Total Tax - $ Tax Calculation Yr 5 Taxable Income Over Not Over 300,000 350,000 200,000 225,000 225,000 250,000 1,510,000 1,745,000 58,325,000 67,990,000 40,000,000 45,000,000 34,999,998 38,333,331 18,333,333 + Income $ - ACCT 522 Rate Taxable Inc 15% 25% 34% 39% 34% 35% 38% 35% Total Tax KAREEM TANNOUS Total Tax $ - DR. BOYLAN Your Company Name Principal $ i Pymts/Yr Years Pmt # 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 ACCT 522 0.00% 0 0 #DIV/0! PAYMENT Mortgage Amortization Schedule #DIV/0! 0 INTEREST PRIN RED PRINCIPAL $ #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! INTEREST EXP X1 #DIV/0! X2 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! KAREEM TANNOUS DR. BOYLAN Your Company Name 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 ACCT 522 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Mortgage Amortization Schedule #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! KAREEM TANNOUS DR. BOYLAN Your Company Name 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 ACCT 522 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Mortgage Amortization Schedule #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! KAREEM TANNOUS DR. BOYLAN X3 #DIV/0! ACCT 522 X4 #DIV/0! X5 #DIV/0! KAREEM TANNOUS DR. BOYLAN ACCT 522 KAREEM TANNOUS DR. BOYLAN ACCT 522 KAREEM TANNOUS DR. BOYLAN Your Company Name Marketable Securities Investments For Years Ending X0 - X5 Marketable Securities Interest Revenue IRR on Corporate Securities Marketable Securities Interest Revenue IRR on Municipal Securities ACCT 522 X0 X1 X2 X3 X4 X5 X0 X1 X2 X3 X4 X5 5.4% 4.6% KAREEM TANNOUS DR. BOYLAN Your Company Name Stock Price For Years Ending X0 - X5 X0 X1 X2 X3 X4 X5 Common Stock Paid in Capital Treasury Stock Shares Outstanding Par Value Stock Price Net Income Earnings per Share P/E ACCT 522 KAREEM TANNOUS DR. BOYLAN Your Company Name Company Ratios For Years Ending X0 - X5 X0 Liquidity Current Ratio Quick Ratio Debt Leverage Debt to Equity Ratio Debt to Assets Ratio Interest Interest Coverage Ratio Profitability Net Profit Margin Ratio Return on Assets Ratio Return on Equity Ratio X1 ACCT 522 X3 X4 X5 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Effeciency Inventory Turnover Ratio Total Asset Turnover Ratio A/R Turnover Ratio Average Collection Period Days in Inventory Total Current Assets Total Assets Inventories Total Current Liabilities Total Liabilities Total Equity Income (EBDT) Annual Interest Expense Net Income after Taxes Sales Revenue Cost of Good Sold Accounts Payable Accounts Receivable X2 $ $ $ $ $ $ $ - $ $ - $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ - KAREEM TANNOUS $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ AVERAGES DR. BOYLAN Liquidity Data 1000% 900% 800% 700% 600% 500% 400% 300% 200% 100% 0% Quick Ratio 1 2 3 Current Ratio 4 5 ACCT 522 KAREEM TANNOUS DR. BOYLAN Leverage Data 1000% 900% 800% 700% 600% 500% 400% 300% 200% 100% 0% Debt to Equity Ratio 1 2 3 Debt to Assets Ratio 4 5 ACCT 522 KAREEM TANNOUS DR. BOYLAN 1000% 900% 800% 700% 600% 500% 400% 300% 200% 100% 0% X1 X2 X3 X4 X5 ACCT 522 KAREEM TANNOUS DR. BOYLAN Profitability Data 1000% 900% 800% 700% 600% 500% 400% 300% 200% 100% Net Profit Margin Ratio 0% Return on Equity Ratio 1 2 3 Return on Assets Ratio 4 5 ACCT 522 KAREEM TANNOUS DR. BOYLAN Efficiency Data 1000% 900% 800% 700% 600% 500% 400% 300% 200% 100% A/R Turnover Ratio 0% Total Asset Turnover Ratio 1 2 3 Inventory Turnover Ratio 4 5 ACCT 522 KAREEM TANNOUS DR. BOYLAN Average Collection Period (In Days) 10 9 8 7 6 5 4 3 2 1 0 1 2 3 4 5 Days in Inventory 10 9 8 7 6 5 4 3 2 1 0 1 2 3 4 5 ACCT 522 KAREEM TANNOUS DR. BOYLAN