Questions
You would like to vacation in Hawaii for one week each year. You can buy a...

You would like to vacation in Hawaii for one week each year. You can buy a time share for a vacation home in Hawaii for $18,500 today and a maintenance fee of $660 per year starting next year. You expect to sell the time share in 10 years for $19,000 . Alternatively you can just pay for the week vacation each year (starting next year). Each year will cost you $1,500 . If your investments earn 5% per year (compounded annually) which alternative is cheaper and by how much in present value terms?

In: Finance

[SHORT] In Excel: Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal...

  • [SHORT] In Excel:



  • Amount of the loan: $500,000
  • Length of the loan: 30 years
  • Payment: Equal annual payment
  • Interest rate: Annual interest rate is 3.0% in year 1, and increases at 0.1% increment every year after that. So Year 2's rate will be 3.1%, Year 3's rate will be 3.2%, etc.

Create a year-by-year table with Year, Beginning balance, PMT, interest, principal, and ending balance.

Make sure to create a column to reflect floating interest rates.

Make sure to utilize goal seek to calculate loan annual payment.

In: Finance

D0= $2, rs =13%, the growth rate of dividend, gL= 5% Estimate the intrinsic stock value,...

D0= $2, rs =13%, the growth rate of dividend, gL= 5%

Estimate the intrinsic stock value, (P_0 ) ̂, and then the Dividend Yield (Yd) and Capital Gain Yield (CGY) from above data

Estimate the expected or intrinsic stock price today, (P_0 ) ̂, if non-constant growth of dividend is 30% for year 0 to year 1, 20% for year 1 to year 2, 10% for year 2 to year 3; the growth rate of dividend is constant, gL= 5% after year 3; D0 = $2; Rs =13%.

*please show work and formulas used

In: Finance

You would like to vacation in Hawaii for one week each year. You can buy a...

You would like to vacation in Hawaii for one week each year.
You can buy a time share for a vacation home in Hawaii for $19,000 today and a maintenance fee of $660 per year starting next year. You expect to sell the time share in 10 years for $19,000 .
Alternatively you can just pay for the week vacation each year (starting next year). Each year will cost you $1,500 .

If your investments earn 5% per year (compounded annually) which alternative is cheaper and by how much in present value terms?

In: Finance

Bigg company is evaluation two projects for next year’s capital budgeting. The after-tax cash flow ($)...

Bigg company is evaluation two projects for next year’s capital budgeting. The after-tax cash flow ($) (including depreciation) are following:

Project A                              Project B

Year 0    -7500 -17500

Year 1    2000                                       5600

Year 2    2000                                       5600

Year 3    2000                                       5600

Year 4    2000                                       5600

Year 5    2000                                       5600

Year 6    4000                                       9000

If company’s WACC is 13%, find NPV, IRR, Payback and discount payback for each project. If the projects are mutually exclusive what is your recommendation to the company.(show working please)

In: Finance

GM is considering two mutually exclusive projects, A and B. Project A costs $150,000 and is...

GM is considering two mutually exclusive projects, A and B. Project A costs $150,000 and is expected to generate $50,000 in year one, $85,000 in year two, and $35,000 per year in years 3 and 4. Project B costs $120,000 and is expected to generate $64,000 in year one, $45,000 in year two, $25,000 in year three, and $55,000 in year four. GM's required rate of return for these projects is 10%. GM decides to use NPV to evaluate these projects. Which project or projects will they choose?

Project A

Project B

Projects A&B

GM would reject both projects

In: Finance

Three different companies each purchased trucks on January 1, Year 1, for $60,000. Each truck was...

Three different companies each purchased trucks on January 1, Year 1, for $60,000. Each truck was expected to last four years or 250,000 miles. Salvage value was estimated to be $5,000. All three trucks were driven 79,000 miles in Year 1, 47,000 miles in Year 2, 51,000 miles in Year 3, and 74,000 miles in Year 4. Each of the three companies earned $49,000 of cash revenue during each of the four years. Company A uses straight-line depreciation, company B uses double-declining-balance depreciation, and company C uses units-of-production depreciation.

Answer each of the following questions. Ignore the effects of income taxes.

Required

  1. a-1. Calculate the net income for Year 1.

  2. a-2. Which company will report the highest amount of net income for Year 1?

  3. b-1. Calculate the net income for Year 4.

  4. b-2. Which company will report the lowest amount of net income for Year 4?

  5. c-1. Calculate the book value on the December 31, Year 3, balance sheet.

  6. c-2. Which company will report the highest book value on the December 31, Year 3, balance sheet?

  7. d-1. Calculate the retained earnings on the December 31, Year 4, balance sheet.

  8. d-2. Which company will report the highest amount of retained earnings on the December 31, Year 4, balance sheet?

    e. Which company will report the lowest amount of cash flow from operating activities on the Year 3 statement of cash flows?

In: Finance

Three different companies each purchased trucks on January 1, Year 1, for $72,000. Each truck was expected to last four years or 200,000 miles.

Three different companies each purchased trucks on January 1, Year 1, for $72,000. Each truck was expected to last four years or 200,000 miles. Salvage value was estimated to be $7,000. All three trucks were driven 67,000 miles in Year 1, 42,000 miles in Year 2, 40,000 miles in Year 3, and 62,000 miles in Year 4. Each of the three companies earned $61,000 of cash revenue during each of the four years. Company A uses straight-line depreciation, company B uses double-declining-balance depreciation, and company C uses units-of-production depreciation. Answer each of the following questions. Ignore the effects of income taxes. Required a-1. Calculate the net income for Year 1. a-2. Which company will report the highest amount of net income for Year 1? b-1. Calculate the net income for Year 4. b-2. Which company will report the lowest amount of net income for Year 4? c-1. Calculate the book value on the December 31, Year 3, balance sheet. c-2. Which company will report the highest book value on the December 31, Year 3, balance sheet? d-1. Calculate the retained earnings on the December 31, Year 4, balance sheet. d-2. Which company will report the highest amount of retained earnings on the December 31, Year 4, balance sheet? e. Which company will report the lowest amount of cash flow from operating activities on the Year 3 statement of cash flows?

In: Accounting

Profitability Ratios East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial...

Profitability Ratios

East Point Retail, Inc., sells professional women's apparel through company-owned retail stores. Recent financial information for East Point is provided below (all numbers in thousands).

Fiscal Year 3 Fiscal Year 2
Net income $156,200 $80,500
Interest expense 3,200 12,000
Fiscal Year 3 Fiscal Year 2 Fiscal Year 1
Total assets (at end of fiscal year) $2,334,072 $2,220,214 $1,984,332
Total stockholders' equity (at end of fiscal year) 1,151,547 1,128,745 834,669

Assume the apparel industry average return on total assets is 8.0%, and the average return on stockholders’ equity is 15.0% for the year ended April 2, Year 3.

a. Determine the return on total assets for East Point for fiscal Years 2 and 3. Round to one decimal place.

Fiscal Year 3 %
Fiscal Year 2 %

b. Determine the return on stockholders' equity for East Point for fiscal Years 2 and 3. Round to one decimal place.

Fiscal Year 3 %
Fiscal Year 2 %

c. The return on stockholders' equity is greater than  the return on total assets due to the positive  use of leverage.

d. During fiscal Year 3, East Point’s results were weak  compared to the industry average. The return on total assets for East Point was less  than the industry average. The return on stockholders’ equity was less  than the industry average. These relationships suggest that East Point has less  leverage than the industry, on average.

In: Accounting

Monhegan Computers is considering whether to begin offering customers the option to have their old personal...

Monhegan Computers is considering whether to begin offering customers the option to have their old personal computers recycled when they purchase new systems. The recycling system would require Monhegan to invest $650,000 in the grinders and magnets used in the recycling process (that is at t=0). The company estimates that for each system it recycles, it would generate $1.75 in incremental revenues from the sale of scrap metal and plastics. The recycled computers will cost the firm nothing, but it will cost the firm $0.25 per unit to dispose of the toxic elements from the recycled computer. The firm expects to use the recycling equipment for five years, and at t=5 sell the recycling equipment for $30,000. The machinery will be depreciated at the five-year MACRS depreciation schedule. (The MACRS depreciation schedule for a five year life is: year 1--20%, year 2--32%, year 3—19.2%, year 4—11.52%, year 5—11.52%, year 6—5.76%. Note that a five year life lasts 6 years because of the half year convention for the first year, but the machinery is sold at t=5.) During the life of the machine no new capital expenditures or investments in working capital will be required. Monhegan estimates that in the first year of the recycling project, it could recycle 110,000 PCs and that this number will grow by 20% per year over the remaining four-year life of the recycling equipment. Monhegan uses a 14% discount rate to analyze capital expenditures and pays taxes equal to 30%. You must calculate the PFCFs. What is the project’s NPV?

In: Finance