Module 3 Individual Assignment
· Submit answers in Word or Excel document format.
· Please write the answers in your own words – do not paraphrase contents from PowerPoint lecture, textbook, and articles or from any outside sources.
· Please do not share answers with other teams.
Problems (100 points, address any 10 questions below)
You are the financial manager of Wal-Mart who will submit a report on this year’s (2014) financial transactions to the company’s CFO Charles Holley. You want to verify that the following estimates prepared by your staff are correct.
[Note: 2014 is year 0, 2015 is year 1, and so forth].
Financial Transaction 1
Your department will set aside a lump sum fund this year in order to pay for a planned purchase of a $140,000-equipment in 2020. How much should be deposited this year to pay for this purchase if the current market interest rate is 3.50 percent on an annual basis?
Staff Estimate: $80,000 (please verify)
Financial Transaction 2
You are recommending that the fund in financial transaction 1 should be invested at a slightly higher rate of 4.25 percent. If so, please provide an estimate for this higher rate. Explain to the CFO why your estimate is lower than the estimate in transaction 1.
Financial Transaction 3
Wal-Mart just bought an investment property for $10 million that it will sell in 2020. The return on this investment (i.e., interest rate, growth rate, etc.) is 4.5 percent per year. At what price can this property be sold in 2020?
Staff Estimate: $12 million (please verify)
Financial Transaction 4
The CFO likes to know the annual growth rate in sales for five high-volume stores in Dallas over the last five years, from 2009 to 2014. Total annual sales in these five stores were $150 million in 2009 and $195 million in 2014. What is the growth rate in sales?
Staff Estimate: 8.5% (please verify)
Financial Transaction 5
Based on the growth rate estimate in transaction 4, present your sales forecast for a new high-volume store for the year 2020. Current sales for the new high-volume store are $32 million.
Staff Estimate: $45 million (please verify)
Financial Transaction 6
The property division of Wal-Mart wants to determine the value (this year’s value) of a property in Pearland, Texas. This property generates an annual income of $2 million. It is expected that this annual income of this property will continue through year 2020 at which time it will sold for a market value of $25 million. Wal-Mart can invest its income at 3.50 percent annually. What is the value of this property this year?
Staff Estimate: $16 million (please verify)
Financial Transaction 7
Your department will deposit $1.50 million profit every year in an account paying 5.50 percent interest. How much fund will you accumulate at the end of 2020?
Staff Estimate: $15 million (please verify)
Financial Transaction 8
Wal-Mart borrowed $200 million this year from Chase at 3.80 percent annual rate. This loan will be repaid in annual payments until 2020. How much will Wal-Mart pay annually to pay off this loan?
Staff Estimate: $21 million pmt per year (please verify)
Financial Transaction 9
Wal-Mart needs to retire a $30 million loan in 2020. To retire, it plans to make equal annual payments into a fund (called Sinking Fund) paying an annual return of 2.75 percent. What is the annual payment into the fund?
Staff Estimate: $2 million payment per year (please verify)
Financial Transaction 10
In 2004, Wal-Mart invested $25 million in various financial securities. These investments are generating annual income of $2 million. The market value of these investments this year is $30 million. What is the overall return on investment in these financial securities so far?
Staff Estimate: 4.68 percent (please verify)
Financial Transaction 11
Wal-Mart is borrowing $180 million this year to build a warehouse in Sealy, Texas. The loan will be repaid in 2020 with annual payments of $30 million. What is the interest rate on this loan?
Staff Estimate: 6.25 percent (please verify)
Financial Transaction 12
In 2004, Wal-Mart bought a piece of land in Richmond, Texas, for $5 million. The CFO likes to sell this land this year at the market price of $6.5 million, and determine the rate of return. What is the return on investment in this land?
Staff Estimate: 3.90 percent (please verify)
|Due By (Pacific Time)||02/03/2015 12:00 pm|
out of 1971 reviews
out of 766 reviews
out of 1164 reviews
out of 721 reviews
out of 1600 reviews
out of 770 reviews
out of 766 reviews
out of 680 reviews