The Balance Sheet and Income statement for Clear Water Company are Shown Below: Finance Assignment, NUS, Singapore

Question 1

The balance sheet and income statement for Clear Water Company are shown below. They represent the financials of the company for both the current year and the previous year

A template table is provided for financial ratios. The current year ratios are yet to be calculated. Corresponding ratios for the previous year’s results at Clear Water Company are provided. Corresponding ratios for the historical average of the same industry sector as Clear Water Company are also provided.

a. Using the company information provided, compute the current year ratios. (Assume 365 days per year)

b. Discuss how these ratios compare with the company’s performance last year.

c. Discuss how each of the company’s five (5) main groups of ratios (liquidity, asset efficiency, profitability, return, and solvency) compares with the industry’s performance.

d. Deconstruct Clear Water’s current year Return on Equity into its three (3) components, using Dupont analysis. Compare the result with the ones of the previous year.

Question 2

After a long confinement period, you are looking for a tour around the world. To finance your dream, the bank Take It For Granted offers you a $58,600 loan in the form of a 60-month fixed payment at an annual rate of 5.2%.

(a) Compute what the monthly payment will be.

(b) Compute the interest and the principal repaid for months 1, 15, and 45.

(c) Describe and explain the observations you are able to make over the differences you can identify on the amount of principal being repaid and the amount of interest between month 1 and month 45.

Instead of going for the loan, you decide to go for a tour of New Zealand and tap into the insurance policy your family had set up for you ten years ago. Your parents made six consecutive contributions to the insurance company as follows:

• At inception then at the end of the first and second year $800
• At the end of the third, fourth, and fifth-year $1,000

After the sixth payment, no more payments were made. After ten years, the insurance policy can now be terminated, and you will be due to receive $8,000.

The relevant interest rate for investing the same amount of money in an interest-bearing account was 5 percent for the first three years and 3 percent for all subsequent years.

(d) Compute the value of the contributions made on your policy at the end of the third, sixth and tenth year in the case where they would have been invested in an interest-bearing account instead of the insurance policy.

(e) Determine and discuss whether the policy was worth buying.

Question 3

I am investing $50,000 right now and will add $8,000 each year for the next 10 years. The expected return of this investment is 6.5% per year.

(a) Compute the amount you will be expected to have at the end of the tenth year.

For each of the following sub-question, assume that only one variable of the investment is changed, while all other variables remain identical to the ones you used to compute the result of sub-question (a)

(b) Compute the amount expected at the end of the tenth year if the initial investment contribution was increased by $10,000.

(c) Compute the amount expected at the end of the tenth year if you withdrew from the investment $10,000 at the end of the sixth year instead of contributing $8,000.

(d) Compute the amount expected at the end of the tenth year if the expected return becomes 3.25% compounded semi-annually and you contribute $4,000 every six months instead of $8,000 every year. 

(e) Determine the amount expected at the end of the fifteenth year assuming you carry on investing $8,000 every year and the expected return for year 11 to 15 is 7%.

(f) Determine by which year your investment will reach the $100,000 mark.