Help needed please answer all the questions need it in excel format Thank you

Please Answer all questions its needed in excel format the first one I posted was a bit mixed up 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 Question 2 25marks 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. Part A (10 marks) 25marks The Finance Manager wishes to determine the current value of its stock and seeks your assistance. The following anticipated dividend payout structure information is provided: Dewpoint Inc. is expected to pay dividends over the next four years as follows: Thereafter, the company is expected to increase dividends by an annual rate of 2.25%. The company assumes a required rate of return of 15%. Required: Given the above, what should be the current price of Dewpoint Inc.'s common share price? 10 marks Part B (15 marks) You have been given the task of evaluating two (2) mutually exclusive projects that Dewpoint Inc. is considering during the expansion process. The projected cashflows of both projects are as follows: 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. Part A (15 marks) 25 marks Utilize the 2023 financial statements for Dewpoint Inc. provided on page 2 and assume that the company is currently operating at below operating capacity. Sales are forecasted to increase by 8% and current assets, costs, and accounts payable are expected to vary by the same amount. The tax rate and dividend payout ratio will remain constant. Depreciation and Interest Expense will remain unchanged. Required: a) Prepare the pro forma Income Statement and Balance Sheet for 2024. Round all pro forma figures to the nearest whole number. 12 marks b) Based on your computations in (a) above, is external financing needed or does the company have excess financing? If so, by how much and what options does it have? 3 marks Part B (10 marks) In light of the planned expansion Dewpoint Inc. is considering raising financing through a bond offering. Details of the proposed bond offering are provided below: Coupon Rate: 8% Time to Maturity: 8 years Frequency of interest payments: Quarterly Required: Given a current yield to maturity of 5.20%, how much should an investor be willing to pay for the $1,000 face value of this bond? The company currently assumes a required return of 15%. The following PV factors are provided: Required: (a) Using the following, indicate which Project should be chosen under each selection criteria: i. Payback ii. Discounted 6 marks Present 3 marks (NPV) Value b) Compute the Internal Rate of Return (IRR) for Project 2 only, given that it falls between 15% and 18%. PV factors at 18% are provided below. 6 marks Part A (15 marks) 25 marks Utilize the 2023 financial statements for Dewpoint Inc. provided on page 2 and assume that the company is currently operating at below operating capacity. Sales are forecasted to increase by 8% and current assets, costs, and accounts payable are expected to vary by the same amount. The tax rate and dividend payout ratio will remain constant. Depreciation and Interest Expense will remain unchanged. Required: a) Prepare the pro forma Income Statement and Balance Sheet for 2024. Round all pro forma figures to the nearest whole number. 12 marks b) Based on your computations in (a) above, is external financing needed or does the company have excess financing? If so, by how much and what options does it have? 3 marks Part B (10 marks) In light of the planned expansion Dewpoint Inc. is considering raising financing through a bond offering. Details of the proposed bond offering are provided below: Coupon Rate: 8% Time to Maturity: 8 years Frequency of interest payments: Quarterly Required: Given a current yield to maturity of 5.20%, how much should an investor be willing to pay for the $1,000 face value of this bond? 25 marks The Finance Manager, in implementing the strategic management of the company, is required to determine Dewpoint Inc.'s actual Weighted Average Cost of Capital (WACC). Debt: The company has $5,000 face value bonds that currently sell for 105% of face value. The bonds carry an 8% coupon, pay interest annually, and mature in 10 years. Common Stock: 3,000 shares outstanding with a market price per share of $15.00. The company intends to pay a dividend of $1.50 next year; dividends are expected to grow by 2% annually. Preference Shares: 200 shares of preferred stock at a price of $10 per share and an annual dividend of $2 per share. Additional Information: The Company's Tax rate is 30%. Required: Calculate the Weighted Average Cost of Capital for Dewpoint Inc. 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 Question 2 25marks 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. 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. 25 marks Part A (10 marks) The Finance Manager wishes to determine the current value of its stock and seeks your assistance. The following anticipated dividend payout structure information is provided: Dewpoint Inc. is expected to pay dividends over the next four years as follows: Thereafter, the company is expected to increase dividends by an annual rate of 2.25%. The company assumes a required rate of return of 15%. Required: Given the above, what should be the current price of Dewpoint Inc.'s common share price? 10 marks Part B (15 marks) You have been given the task of evaluating two (2) mutually exclusive projects that Dewpoint Inc. is considering during the expansion process. The projected cashflows of both projects are as follows: The company currently assumes a required return of 15%. The following PV factors are provided: Required: (a) Using the following, indicate which Project should be chosen under each selection criteria: i. Payback ii. (NPV) Discounted 6 marks Present Value b) Compute the Internal Rate of Return (IRR) for Project 2 only, given that it falls between 15% and 18%. PV factors at 18% are provided below. 6 marks Part A (15 marks) 25 marks Utilize the 2023 financial statements for Dewpoint Inc. provided on page 2 and assume that the company is currently operating at below operating capacity. Sales are forecasted to increase by 8% and current assets, costs, and accounts payable are expected to vary by the same amount. The tax rate and dividend payout ratio will remain constant. Depreciation and Interest Expense will remain unchanged. Required: a) Prepare the pro forma Income Statement and Balance Sheet for 2024. Round all pro forma figures to the nearest whole number. 12 marks b) Based on your computations in (a) above, is external financing needed or does the company have excess financing? If so, by how much and what options does it have? 3 marks Part B (10 marks) In light of the planned expansion Dewpoint Inc. is considering raising financing through a bond offering. Details of the proposed bond offering are provided below: Coupon Rate: 8% Time to Maturity: 8 years Frequency of interest payments: Quarterly Required: Given a current yield to maturity of 5.20%, how much should an investor be willing to pay for the $1,000 face value of this bond? 25 marks The Finance Manager, in implementing the strategic management of the company, is required to determine Dewpoint Inc.'s actual Weighted Average Cost of Capital (WACC). Debt: The company has $5,000 face value bonds that currently sell for 105% of face value. The bonds carry an 8% coupon, pay interest annually, and mature in 10 years. Common Stock: 3,000 shares outstanding with a market price per share of $15.00. The company intends to pay a dividend of $1.50 next year; dividends are expected to grow by 2% annually. Preference Shares: 200 shares of preferred stock at a price of $10 per share and an annual dividend of $2 per share. Additional Information: The Company's Tax rate is 30\%. Required: Calculate the Weighted Average Cost of Capital for Dewpoint Inc