XYZ stock price and dividend history are as follows:
| Year | Beginning-of-Year Price | Dividend Paid at Year-End | ||||||
| 2015 | $ | 120 | $ | 2 | ||||
| 2016 | 129 | 2 | ||||||
| 2017 | 115 | 2 | ||||||
| 2018 | 120 | 2 | ||||||
An investor buys six shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all seven remaining shares at the beginning of 2018.
a. What are the arithmetic and geometric average
time-weighted rates of return for the investor? (Do not
round intermediate calculations. Round your answers to 2 decimal
places.)
b-1. Prepare a chart of cash flows for the four
dates corresponding to the turns of the year for January 1, 2015,
to January 1, 2018. (Negative amounts should be indicated
by a minus sign.)
b-2. What is the dollar-weighted rate of return?
(Hint: If your calculator cannot calculate internal rate
of return, you will have to use a spreadsheet or trial and
error.)
In: Finance
|
Project 1 |
Project 2 |
|
|
Initial Year 1 |
$ 35,000 |
$ 35,000 |
|
Year 2 |
5,000 |
16,000 |
|
Year 3 |
16,000 |
23,000 |
|
Year 4 |
22,000 |
12,000 |
|
Year 5 |
(3,600) |
11,600 |
|
Estimated scrap value |
5,000 |
5,000 |
Cost of capital 14%
Calculate:
In: Finance
A 20-year-old student wants to save $1000 a year for her retirement. Every year she invests $1000 in a mutual fund with an expected annual return of 8%. How much money will she have when she is 65 years old? Assume that she invests right away and did not have any money in her saving account.
Part B
The same student, she wants to save $100 a month instead of $1000 a year. How much money will she have when she is 65 years old?
Part C
The same student, she wants to have $1,000,000 in her account when she is 65 years old. How much money she should invest per month? If her mom gives her an additional $1000 for investing at the beginning. Use this as a present value.
In: Finance
XYZ's stock price and dividend history are as follows:
| Year | Beginning-of-Year Price | Dividend Paid at Year-End | |||||||||
| 2016 | $ | 185 | $ | 6 | |||||||
| 2017 | 195 | 6 | |||||||||
| 2018 | 170 | 6 | |||||||||
| 2019 | 185 | 6 | |||||||||
An investor buys three shares of XYZ at the beginning of 2016, buys another two shares at the beginning of 2017, sells one share at the beginning of 2018, and sells all four remaining shares at the beginning of 2019.
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answer to 2 decimal places. Do not round other calculations.)
b. What is the dollar-weighted rate of return? (Hint: Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2016, to January 1, 2019. If your calculator cannot calculate internal rate of return, you will have to use trial and error.) (Round your answers to 4 decimal places. Negative amount should be indicated by a minus sign.)
In: Finance
XYZ stock price and dividend history are as follows:
| Year | Beginning-of-Year Price | Dividend Paid at Year-End | ||||||
| 2015 | $ | 114 | $ | 5 | ||||
| 2016 | 120 | 5 | ||||||
| 2017 | 100 | 5 | ||||||
| 2018 | 105 | 5 | ||||||
An investor buys four shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all five remaining shares at the beginning of 2018.
a. What are the arithmetic and geometric average
time-weighted rates of return for the investor? (Do not
round intermediate calculations. Round your answers to 2 decimal
places.)
b-1. Prepare a chart of cash flows for the four
dates corresponding to the turns of the year for January 1, 2015,
to January 1, 2018.
In: Finance
1-4 $25,000 per year (payments at the end of the year)
5-9 $20,000 per year (payments at the end of the year)
Assume an interest rate of 6% compounded annually. Calculate the present value of the stream of cash flows above.
In: Accounting
PINNACLE PLUS Horizontal Analysis Increase (Decrease) in the Current year (versus Previous year) Current Year Previous Year Amount Percentage Income Statement Sales Revenue $120,000 $106,000 % Cost of Goods Sold 54,000 49,000 Gross Profit 66,000 57,000 Operating Expenses 41,000 35,500 Interest Expense 5,000 5,000 Income before Income Tax Expense 20,000 16,500 Income Tax Expense (30%) 6,000 4,950 Net Income $14,000 $11,550 % Balance Sheet Cash $77,900 $43,000 % Accounts Receivable, Net 19,000 10,000 Inventory 26,000 40,000 Property and Equipment, Net 96,000 110,000 Total Assets $218,900 $203,000 % Accounts Payable $44,000 $36,000 % Income Tax Payable 3,000 1,500 Note Payable (long-term) 50,000 50,000 Total Liabilities 97,000 87,500 Common Stock (par $10) 87,000 87,000 Retained Earnings† 34,900 28,500 Total Liabilities and Stockholders’ Equity $218,900 $203,000 % †During the current year, cash dividends amounting to $7,600 were declared and paid.
In: Accounting
Wal Mart Stores Consolidated Income Statement (amounts in millions)
Year 4 Year 5 Year 6 Year 7
Sales Revenues $83,412 $94,749 $106,146
Cost of Goods Sold $65,586 $74,564 $83,663
Accounts Receivables $ 690 $ 900 $ 853 $ 845
Inventories $11,014 $14,064 $15,989 $ 15,897
Question # 6
Please calculate the accounts receivable and inventory ratios for years 5 thru 7.
Question # 7
Does any of the inventory scenarios and interpretations that we discussed at the end of session 4 apply here?
Question # 8
Why does Wal Mart have such a big difference between its account receivable turnover ratios and inventory ratios? Does it have anything to do with the line of business it is active?
In: Accounting
| Consider the following table for an eight-year period: |
| Year | T-bill return | Inflation |
| Year 1 | 7.36% | 8.64% |
| Year 2 | 8.39 | 12.27 |
| Year 3 | 5.94 | 6.87 |
| Year 4 | 5.42 | 4.93 |
| Year 5 | 5.52 | 6.63 |
| Year 6 | 7.99 | 8.95 |
| Year 7 | 10.63 | 13.22 |
| Year 8 | 12.45 | 12.45 |
| Requirement 1: |
|
Calculate the average return for Treasury bills and the average annual inflation rate (consumer price index) for this period. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Average return for Treasury bills | % |
| Average annual inflation rate | % |
| Requirement 2: |
|
Calculate the standard deviation of Treasury bill returns and inflation over this time period. (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Standard deviation of Treasury bills | % |
| Standard deviation of inflation | % |
| Requirement 3: |
| (a) |
Calculate the real return for each year. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).) |
| Year | Real return |
| Year 1 | % |
| Year 2 | % |
| Year 3 | % |
| Year 4 | % |
| Year 5 | % |
| Year 6 | % |
| Year 7 | % |
| Year 8 | % |
| (b) |
What is the average real return for Treasury bills?
(Negative amount should be indicated by a minus
sign. Do not round intermediate calculations.
Enter your answer as a percentage |
| Average real return for Treasury bills | % |
In: Finance
XYZ's stock price and dividend history are as follows:
| Year | Beginning-of-Year Price | Dividend Paid at Year-End | |||||||||
| 2017 | $ | 125 | $ | 7 | |||||||
| 2018 | 145 | 7 | |||||||||
| 2019 | 115 | 7 | |||||||||
| 2020 | 125 | 7 | |||||||||
An investor buys three shares of XYZ at the beginning of 2017, buys another two shares at the beginning of 2018, sells one share at the beginning of 2019, and sells all four remaining shares at the beginning of 2020.
a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answer to 2 decimal places. Do not round other calculations.)
b. What is the dollar-weighted rate of return? (Hint: Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2017, to January 1, 2020. If your calculator cannot calculate IRR, you will have to use trial and error or a spreadsheet program.) (Round your answers to 4 decimal places. Negative amount should be indicated by a minus si
In: Finance