Use an Excel spreadsheet and/or tables to present your calculations. Show all workings.

Mark

Part 1

Liquidity Analysis Calculation: The King Carpet Company has $3, 000, 000 in cash and a total of $12,000,000 in current assets. The firm’s current liabilities equal $6,000,000 such that the firm’s current ratio equals 2. The company’s managers want to reduce the firm’s cash holdings to $1,000,000 by paying $500,000 in cash to expand the firm’s truck fleet, and using $1,500,000 in cash to retire a short-term note. Central to the decisions is the issue of liquidity.

a. What does the term liquidity mean in the context of the firm’s financial condition?

b. What financial ratios can you use to analyse and assess liquidity?

c. If they carry this plan through, demonstrate the effect on the firm’s current ratio?

d. How we can we determine whether The King Carpet Company is more or less liquid than other firms?

15 Marks

Part 2

Profitability Analysis Calculation: The Allen Corporation had sales in 2015 of $65 million, total assets of $42 million and total liabilities of $20 million. The annual interest rate on the company’s debt is 6%, and its tax rate is 30%. The operating profit margin is 12%.

a. Compute the firm’s 2015 operating profit and net profit.

b. How would you determine if the frim was achieving reasonable profit margins?

c. Calculate the firm’s return on assets and return on equity (hint: you can assume that interest must be paid on all of the firm’s liabilities) and describe what aspect of the firm’s performance you are measuring.

Use an Excel spreadsheet and/or tables to present your calculations. Show all workings.

Mark

Part 1

Future Value Calculation: ‘Saving for your first house’ – You are hoping to buy a house in the future and recently received an inheritance of $50,000. You intend to use your inheritance as a deposit on your house.

a. If you put your inheritance in an account that earns 7% interest compounded annually, how many years will it be before your inheritance grows to $75 000?

b. If you let your money grow for 10.25 years at 7% compounded annually, how much will you have?

c. How long will it take your money to grow to $75 000 if you move it into an account that pays 3% compounded annually?

d. How long will it take your money to grow to $75 000 if you move it into an account that pays 11% compounded annually?

e. What does all this tell you about the relationship among interest rates, time and future sums?

20 Marks

Part 2

Present Value: Sarah Wiggum would like to make a single investment and have $2 million at the time of her retirement in 35 years. She has found a managed fund that will earn 4% annually.

a. How much will Sarah have to invest today?

b. What if Sarah has a finance degree and learned how to earn a 14% annual return? How soon could she then retire?

Use an Excel spreadsheet and/or tables to present your calculations. Show all workings.

Mark

Part 1

Calculating rates of return: On 12 December 2007, the ordinary shares of Qantas Airways Ltd (QAN) were trading for $5.75.

One year later, the shares sold for $2.24. During that period, Qantas paid dividends totalling $0.35.

a. What rate of return would you have earned on your investment had you purchased the shares on 12 December 2007 and sold them on 12 December 2008?

b. Describe, in your own words, the concept of a realised of return.

c. How do cash dividends affect the realised rate of return from investing in ordinary shares?

d. Why is volatility in an investment’s rate of return a reasonable indication of the risk of an investment?

20 Marks

Part 2

Calculating rates of return: The S&P/ASX 200 share price index represents a portfolio which comprises the 200 largest companies listed on the Australian Securities Exchange. On 12 December 2007, the index had a value of 6615.2 and on 12 December 2008 the index had a value of 3510.4.3. If the average dividend paid on the shares in the index is approximately 4% of the value of the index at the beginning of the year, what is the rate of return earned on the S&P/ASX 200 index?

What is your assessment of the relative riskiness of the Qantas Airways investment (analysed in the previous problem) compared to investing in the S&P/ASX 200 index (recall from Chapter 2 that you can purchase managed funds that mimic the returns on the index)?

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies.

After making payment, solution is sent within 2 to 5 minutes on your Email ID. But it may take up to 1 hour in case of high load on server. Solution is available in Word or Excel format unless otherwise specified.

Disclaimer : MyAssignmentGuru.com provides assignment and homework help for guidance and reference purpose only. These papers are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.