Question: Help Needed please need it in excel format thank you CASE ANALYSIS - Dewpoint INC. The following financial statement have been provided for Dewpoint Inc.



Help Needed please need it in excel format thank you
CASE ANALYSIS - Dewpoint INC. The following financial statement have been provided for Dewpoint Inc. Part B (10 marks) The Finance Manager would like to analyze the company's performance and requires your assistance: Required: Compute the following ratios for 2023 giving an explanation of each ratio calculated. i. Cash Ratio 2 marks ii. Quick Ratio 2 marks iii. Return on Equity using Du Pont Identity 6 marks Part A (12 marks) As part of your analysis, you are required to analyze the company's sources and uses of cash for 2023. Required: Prepare a Cash Flow Statement for Dewpoint Inc. for the year ended 2023. 12 marks Part B (6 marks) Dewpoint Inc. is considering expansion due to recent improvements in business. Their intention is to finance the expansion by borrowing $350,000 and is considering the following borrowing options for these funds: A : Annual Interest Rate of 9.5%, compounded semiannually B: Annual Interest Rate of 9.25%, compounded monthly C: Annual Interest Rate of 9.55%, compounded annually Required: Advise the company on the best interest rate option for the borrowing of funds. 6 marks Part C (7 marks) The company is considering purchasing a delivery van at a cost of $95,000. The intention is to obtain a 3-year loan from the bank, at an interest rate of 9% per annum. Monthly payments are expected to be made on the loan. Required: a. Calculate Dewpoint's monthly payment on the loan. b. Prepare an Amortization Schedule for the first 3 months of the loan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
