Reference no: EM131357361
(in Excel) Capital Budgeting: Fancy Dust Collectors, Inc. is considering a project to build a new factory to produce luxury snow globes. They estimate the initial cost for the factory and equipment to be $500,000 (this is at t=0), which will be depreciated (to zero) on a straight-line basis over eight years. The equipment and factory will have no salvage value. They expect the project to require a working capital investment of $100,000, which is paid at t = 0 and returned to the firm as a cash inflow at t = 8. They estimate that they will sell 65,000 snow globes in the first year. The opportunity cost of capital (the discount rate) is 15%. The tax rate is 35%. The following estimates apply to each year during the project’s 8-year life:
Annual fixed costs are estimated at $95,000 throughout the life of the project.
A luxury snow globe costs $17 to manufacture, and they will be sold for $21 each.
They estimate that sales of snow globes will increase by 3.0% per year for the life of the project.
Calculate the net income (earnings) from the project for each year of the project.
Calculate the Operating Cash Flow (OCF) for each year of the project.
Calculate the Cash Flow From Assets (CFFA) for each year of the project.
What is the project’s NPV? Based on NPV, should the firm accept the project?
What is the project’s IRR (use the Excel IRR function)? Based on IRR, should the firm accept the project?
Keeping all of the other assumptions the same, what is the minimum number of snow globes the firm can sell in the first year for this project to be accepted? In other words, how many snow globes must be sold in the first year so the project has an NPV of zero? (HINT: In the “Data” tab, Click on the “What If Analysis” icon and choose “Goal Seek”. Then “Set Cell” should be the NPV formula cell, “To Value” should be “0” and “By Changing Cell” should be the cell with the initial sales level of 65,000.) HINT: after using the solver, copy the value as the answer to this part of the question. Then re-input the 65,000 in the first year sales to change the values back to the original amounts used above.
|
Potential currency exposure-substantial exchange rate risk
: What is the business reason for China Noah's potential currency exposure? Does the company really need to subject itself to substantial exchange rate risk? Is the risk "material" to China Noah? Do you think China Noah should hedge?
|
|
How much should a new graduate pay
: How much should a new graduate pay in 10 equal annual payments, starting 2 years from now, in order to repay $30000 load he has received today? The interest rate is 6% per year. This is from Engineering Economic Analysis 12th edition, problem 6-16. A..
|
|
Pension plan is obligated to make disbursements
: A pension plan is obligated to make disbursements of $2.2 million, $3.2 million, and $2.2 million at the end of each of the next three years, respectively. The annual interest rate is 10%. If the plan wants to fully fund and immunize its position, ho..
|
|
What is the annual financing cost of bonds
: General Automobile Corp. has decided to issue three-year foreign bonds in Japan, denominated in 5,000,000,000 Japanese Yen at par. The bonds have an annual coupon rate of 6.0%, and interest is paid annually. If the Yen is expected to appreciate from ..
|
|
Calculate the operating cash flow for year of the project
: Capital Budgeting: Fancy Dust Collectors, Inc. is considering a project to build a new factory to produce luxury snow globes. They estimate the initial cost for the factory and equipment to be $500,000 (this is at t=0), which will be depreciated (to ..
|
|
Pension plan is obligated to make disbursements
: A pension plan is obligated to make disbursements of $2.2 million, $3.2 million, and $2.2 million at the end of each of the next three years, respectively. The annual interest rate is 10%. If the plan wants to fully fund and immunize its position, ho..
|
|
Calculate the PV of cash inflows
: A factory costs $783,285. You forecast that it will produce cash inflows of $378,953 in year 1, $155,000 in year 2, and $230,000 in year 3. The discount rate is 8.50%. Calculate the PV of cash inflows.
|
|
Investment strategy-What would be its gain in dollars
: Smart Banking Corp. can borrow $5 million at six percent annualized, and it can use the proceeds to invest in Canadian dollars at nine percent annualized over a six-day period. The Canadian dollar is worth $0.95 and is expected to be worth $0.94 in s..
|
|
Engineering economic analysis
: How much should a new graduate pay in 10 equal annual payments, starting 2 years from now, in order to repay $30000 load he has received today? The interest rate is 6% per year. This is from Engineering Economic Analysis 12th edition, problem 6-16. A..
|