Question 1 $89,000.00 $61,000.00 Current Assets Current Liabilities Working Capital Y r Question 5 $5,000.00 3.69% 5 X Question 2 Current Assets Current Liabilities Current Ratio $89,000.00 $61,000.00 PV FV Question 6 $15,000.00 $30,000.00 8.00 n IRR Question 7 Question 3 Cash Short Term Investments Accounts Receivable Current Liabilities Quick Ratio $2,100.00 $10,100.00 $40,500.00 $61,000.00 a b 1.62 8.79% 2.95% 5.75% 4.53% d Question 4 e X Y r $5,000.00 3.69% 5 n Question 8 X a 6 b 25 c 15 X 1. Create Excel formula to calculate Working Capital. (1 mark) Working Capital = Current Assets Current Liabilities. 2. Create Excel formula to calculate Current Ratio. (1 mark) Current Assets Current Ratio - Current Liablities 3 Create Excel formula to calculate Quick Ratio. (2 marks) Cash +Short Term Investments + Accounts Receivable Quick Ratio = Current Liabilities 4. Create Excel formula to calculate x,x=y (1+r)". (2 marks) Hintain Excel formula is a b. 5. Create Excel formula to calculate x,x= 012 (2 marks) 6. Create Excel formula to calculate IRR, IRR = 1. (2 marks) 7. Create Excel formula to calculate x x be 1 de) (3 marks) bb 201 40d (3 marks) 8. Create Excel formula to calculate x x Hint, in Excel X is sqrt(x)