Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What are the Ratios missing: : YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 24,765 3,000 26,647 3,000 24,023 3,000 23,931 3,000 26,700 3,000
What are the Ratios missing: :
YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 24,765 3,000 26,647 3,000 24,023 3,000 23,931 3,000 26,700 3,000 (10,000) Net Income Add back depreciation Changes in working capital Accounts Receivable Prepaid Expenses Accounts Payable Customer Deposits Interest payable Taxes Payable Cash flows from operating activities (2,000) (12,000) 2,000 500 4,000 4,000 1,000 1,000 (600) (1,412) 35,011 (4,000) 4,000 3,000 1,000 2,000 1,500 1,800 13,335 36,400 2,000 4,000 1,000 1,000 (600) (50) 34,281 (600) 1,013 18,560 1,491 35,192 Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities (10,000) (15,000) (25,000) Amount paid for equipment Amount paid for furniture & fixtures Cash flow from investing activities (10,000) (15,000) (25,000) E . I - 60,000 Proceeds from bank loan Proceeds from issuing capital Repayment of bank loan Cash flow from financing activities 3. 10,000 (20,000) (20,000) (20,000) (20,000) (10,000) (20,000) 60,000 Net increase (decrease) in cash Add: Beginning cash balance Ending Cash balance 24,023 14,281 35.192 101,400 101,400 (1,440) 99,960 124,971 139,252 174.444 YEAR 1 YEAR 2 YEAR 8 YEAR 5 Revenue 150,000 67,500 82,500 154,500 69,525 84,975 159,135 71,611 87,524 YEAR 4 167,091 75,191 91,900 175,446 78,951 96,495 6,365 Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental Wages office Rent Utilities Insurance Expense Depreciation Operating Income Interest Expense Income before taxes 6,000 6,000 9,600 14,400 3,600 6,180 6,000 9,600 14,400 3,600 6,684 9,000 14,400 14,400 3,600 4,000 3,000 36,817 7,018 9,000 14,400 14,400 3,600 4,000 3,000 41,078 9,000 9,600 14,400 3,600 4,000 3,000 37,559 600 36,959 12,936 24,023 3,000 39,900 1,800 38,100 13,335 24,765 3,000 42,195 1,200 40,995 14,848 26,647 Income taxes 36,817 12,886 23,931 41,078 14,377 26,700 Net Income FORECASTED BALANCE SHEET YEAR1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 Assets 101,400 10,000 174,444 10,000 Cash Accounts Receivable Prepaid Insurance Current Assets Furniture & Fixtures (net) Equipment (net) Total Assets 99,960 12,000 12,000 123,960 13,000 6,000 142,960 111,400 14,000 8,000 133,400 124,971 8,000 8,000 140,971 12,000 4,000 156,971 139,252 6,000 4,000 149,252 11,000 2,000 162,252 184,444 10,000 194,444 5,000 3,000 6,000 4,000 9,000 5,000 600 Liabilities Accounts payable Customer deposits Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities 2,000 1,500 1,800 13,385 18,635 60,000 78,635 4,000 2,000 1,200 14,348 21,548 40,000 61,548 12,886 22,886 14,377 28,377 12,936 21,536 20,000 41,536 22,886 28,377 6,000 4,000 9,000 5,000 Liabilities Accounts payable 5 Customer deposits 5 Interest payable Taxes payable Current Liabilities Bank loan Total Liabilities 2,000 1,500 1,800 13,385 18,635 60,000 78,635 4,000 2,000 1,200 14,348 21,548 40,000 61,548 5,000 3,000 600 12,936 21,536 20,000 41,536 12,886 22,886 14,377 28,377 22,886 28,377 Stockholder's Equity Capital Retained Earnings Total Stockholder's Equity 5 Total Liabilities & Stockholder's Equity 30,000 24,765 54,765 133,400 30,000 51,412 81,412 142,960 40,000 75,435 115,435 156,971 40,000 99,366 139,366 162,252 40,000 126,067 166,067 194,444 RATIOS YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 *ROUND TO TWO DECIMAL PLACES 5.98 5.75 6.55 6.52 6.50 CURRENT RATIO AVERAGE COLLECTION PERIOD PAYABLES TURNOVER 24.33 28.35 18.35 13.11 20.80 TOTAL ASSET TURNOVER 1.08 1.01 1.03 0.90 DEBT RATIO 0.59 0.43 0.26 0.14 0.15 TIMES INTEREST EARNED 22.17 35.16 0.00 0.55 0.00 0.55 0.55 0.55 0.55 0.15 0.17 0.17 0.14 0.15 GROSS PROFIT MARGIN 2. NET PROFIT MARGIN 3 RETURN ON EQUITY 4 5 0.45 0.33 0.21 0.17 0.16 6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started