I was trying to figure out how to do the assumption and assumption explanations? Is this showing the formulas of how we came to this ratio? 
a A- BIU- Merge & Center Alignment ard X & fx G D E F B RATIOS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 F F F F ROUND TO TWO DECIMAL PLACES CURRENT RATIO AVERAGE COLLECTION PERIOD PAYABLES TURNOVER TOTAL ASSET TURNOVER DEBT RATIO TIMES INTEREST EARNED GROSS PROFIT MARGIN NET PROFIT MARGIN 3 RETURN ON EQUITY 4 F F F 5.98 24.33 33.75 1.12 0.59 22.17 55% 17% 45% 5.75 28.35 17.38 1.08 0.43 35.16 55% 17% 33% 6.55 18.35 14.32 1.01 0.26 62.60 55% 15% 21% 6.52 13.11 12.53 1.03 0.14 0.00 55% 14% 17% 6.50 20.80 8.77 0.90 0.15 0.00 55% 15% 16% F F F F F 5 16 18 19 20 21 Sheet1 Type here to search . e H Ce vre e BIU G-A- A. 3 Mer 2 oboard Font Alignment 5 fx A D E F YEAR 4 YEAR 1 YEAR 2 YEAR 3 YEAR 5 24,765 3,000 26,647 3,000 24,023 3,000 23,931 3,000 26,700 3,000 (10,000) (2,000) (12,000) 2,000 500 (600) 1,013 18,560 2,000 1,500 1,800 13,335 36,400 4,000 4,000 1,000 1,000 (600) (1,413) 35,011 2,000 4,000 1,000 1,000 (600) (50) 34,281 (4,000) 4,000 3,000 1,000 1,491 35,192 Net Income Add back depreciation Changes in working capital 3 Accounts Receivable 9 Prepaid Expenses 10 Accounts Payable 11 Customer Deposits 12 Interest payable 13 Taxes Payable 14 Cash flows from operating activities 15 16 17 Amount paid for equipment 18 Amount paid for furniture & fixtures 19 Cash flow from investing activities 20 21 22 Proceeds from bank loan 23 Proceeds from Issuing capital 24 Repayment of bank loan 25 Cash flow from financing activities (10,000) (15,000) (25,000) 60,000 (20,000) (20,000) 10.000 (20,000) 20,000) (10,000) (20,000) 60,000 99.00 124.971 30.000 101.400 101,400 99,960 139 252 27 Net Increase (decrease) in cash 28 Add: Beginning cash balance 29 Ending Cash balance 30 174.444 Balance Sheet Cashflow Statement Income Statement Ready Type here to search a A- BIU- Merge & Center Alignment ard X & fx G D E F B RATIOS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 F F F F ROUND TO TWO DECIMAL PLACES CURRENT RATIO AVERAGE COLLECTION PERIOD PAYABLES TURNOVER TOTAL ASSET TURNOVER DEBT RATIO TIMES INTEREST EARNED GROSS PROFIT MARGIN NET PROFIT MARGIN 3 RETURN ON EQUITY 4 F F F 5.98 24.33 33.75 1.12 0.59 22.17 55% 17% 45% 5.75 28.35 17.38 1.08 0.43 35.16 55% 17% 33% 6.55 18.35 14.32 1.01 0.26 62.60 55% 15% 21% 6.52 13.11 12.53 1.03 0.14 0.00 55% 14% 17% 6.50 20.80 8.77 0.90 0.15 0.00 55% 15% 16% F F F F F 5 16 18 19 20 21 Sheet1 Type here to search . e H Ce vre e BIU G-A- A. 3 Mer 2 oboard Font Alignment 5 fx A D E F YEAR 4 YEAR 1 YEAR 2 YEAR 3 YEAR 5 24,765 3,000 26,647 3,000 24,023 3,000 23,931 3,000 26,700 3,000 (10,000) (2,000) (12,000) 2,000 500 (600) 1,013 18,560 2,000 1,500 1,800 13,335 36,400 4,000 4,000 1,000 1,000 (600) (1,413) 35,011 2,000 4,000 1,000 1,000 (600) (50) 34,281 (4,000) 4,000 3,000 1,000 1,491 35,192 Net Income Add back depreciation Changes in working capital 3 Accounts Receivable 9 Prepaid Expenses 10 Accounts Payable 11 Customer Deposits 12 Interest payable 13 Taxes Payable 14 Cash flows from operating activities 15 16 17 Amount paid for equipment 18 Amount paid for furniture & fixtures 19 Cash flow from investing activities 20 21 22 Proceeds from bank loan 23 Proceeds from Issuing capital 24 Repayment of bank loan 25 Cash flow from financing activities (10,000) (15,000) (25,000) 60,000 (20,000) (20,000) 10.000 (20,000) 20,000) (10,000) (20,000) 60,000 99.00 124.971 30.000 101.400 101,400 99,960 139 252 27 Net Increase (decrease) in cash 28 Add: Beginning cash balance 29 Ending Cash balance 30 174.444 Balance Sheet Cashflow Statement Income Statement Ready Type here to search
