A regional electrical distributor currently has 1,000 customers who buy an average of $5,000 per year, generating a 50% margin. From experience, the company knows that 20% of its customers will not return the next year and it takes an average of $500 to acquire each new customer.

Given a choice of 1) investing $50,000 in a new customer acquisition program for 100 additional customers or 2) investing $50,000 in a new retention program which would take the rate of retention from 80% to 85%, what should the company do? complete the Excel template for both scenarios (customer acquisition and customer retention) to show which option is the most profitable. Assume the new programs are in effect and you are calculating the impact for both beginning Year 1. Also, do not account for the cost of the programs since it doesn't impact the overall conclusion.

Project cash flow and NPV.  The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds​ (1957 replicas). The necessary foundry equipment will cost a total of ​$4 comma 200 comma 000 and will be depreciated using a​ five-year MACRS​ life, The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as​ follows:

Year​ one:  250 Year​ four:  370 Year​ two:  270 Year​ five:  300 Year​ three:  350

If the sales price is ​$30 comma 000 per​ car, variable costs are ​$20 comma 000 per​ car, and fixed costs are ​$1 comma 300 comma 000 ​annually, what is the annual operating cash flow if the tax rate is 30​%? The equipment is sold for salvage for ​$500 comma 000 at the end of year five. Net working capital increases by ​$600 comma 000 at the beginning of the project​ (year 0) and is reduced back to its original level in the final year. Find the internal rate of return for the project using the incremental cash flows.

First, what is the annual operating cash flow of the project for each year from year 1 to year 5 ?

?Next, what is the? after-tax cash flow of the equipment at? disposal?

?Then, what is the incremental cash flow of the project in each fom year? 0 to year 5 ?

?So, what is the IRR of the? project?

The future worth in year 10 of an arithmetic gradient cash flow series for years 1 through 10 is $725,000. If the gradient increase each year, G, is $1750, determine the cash flow in year 1 at an interest rate of 8% per year.

The cash flow in year 1 is $______

Submit a written paper which is 3-4 pages in length (no more than 4-pages), exclusive of the reference page. Your paper should be double spaced in Times New Roman (or its equivalent) font, which is no greater than 12 points in size. The paper should cite at least three sources in APA format. One source can be your textbook.

Please describe the circumstances of the following case study and recommend a course of action. Explain your approach to the problem, perform relevant calculations and analysis, and formulate a recommendation. Ensure your work and recommendation are thoroughly supported.

Case Study:

A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below:

Option 1

• $65,000 for equipment with useful life of 7 years and no salvage value.
• Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate.
• Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year for the remaining years.
• Labor is estimated to start at $70,000 in Year 1, increasing by 3% each year after.

Revenues are estimated to be:

Option 2

• $85,000 for equipment with useful life of 7 years and a $13,000 salvage value
• Maintenance costs are expected to be $3,500 per year and increase by 3% in Year 6 and remain at that rate.
• Materials in Year 1 are estimated to be $20,000 but remain constant at $15,000 per year for the remaining years.
• Labor is estimated to start at $60,000 in Year 1, increasing by 3% each year after.

Revenues are estimated to be:

The company’s required rate of return and cost of capital is 8%.

Management has turned to its finance and accounting department to perform analyses and make a recommendation on which option to choose. They have requested that the four main capital budgeting calculations be done: NPV, IRR, Payback Period, and ARR for each option.

For this assignment, compute all required amounts and explain how the computations were performed. Evaluate the results for each option and explain what the results mean. Based on your analysis, recommend which option the company should pursue.

Superior papers will:

• Perform all calculations correctly.
• Articulate how the calculations were performed, including from where values used in the calculations were obtained.
• Evaluate the results computed and explain the meaning of the results, including why certain measurements are more accurate than others.
• Recommend which option to pursue, supported by well-thought-out rationale, and considering any other factors that could impact the recommendation.

Submit a written paper which is 3-4 pages in length

Please describe the circumstances of the following case study and recommend a course of action. Explain your approach to the problem, perform relevant calculations and analysis, and formulate a recommendation. Ensure your work and recommendation are thoroughly supported.

Case Study:

A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below:

Option 1                                                                                                       

• $65,000 for equipment with useful life of 7 years and no salvage value.                                                                            
• Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate.                                       
• Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year for the remaining years.                              
• Labor is estimated to start at $70,000 in Year 1, increasing by 3% each year after.          

Revenues are estimated to be:

Option 2

• $85,000 for equipment with useful life of 7 years and a $13,000 salvage value
• Maintenance costs are expected to be $3,500 per year and increase by 3% in Year 6 and remain at that rate.
• Materials in Year 1 are estimated to be $20,000 but remain constant at $15,000 per year for the remaining years.
• Labor is estimated to start at $60,000 in Year 1, increasing by 3% each year after.

Revenues are estimated to be:

The company’s required rate of return and cost of capital is 8%.

Management has turned to its finance and accounting department to perform analyses and make a recommendation on which option to choose. They have requested that the three main capital budgeting calculations be done: NPV, IRR, and Payback Period for each option.

For this assignment, compute all required amounts and explain how the computations were performed. Evaluate the results for each option and explain what the results mean. Based on your analysis, recommend which option the company should pursue.

Note:

Please do not copy the answers already here for me. I saw it before posting.

Please do not plagiarise

Please answer all parts.

Superior papers will:

• Perform all calculations correctly.
• Articulate how the calculations were performed, including from where values used in the calculations were obtained.
• Evaluate the results computed and explain the meaning of the results, including why certain measurements are more accurate than others.
• Recommend which option to pursue, supported by well-thought-out rationale, and considering any other factors that could impact the recommendation.

Suppose you have access to the following bond data.

One year zero coupon bond, priced at 98, face value 100. Two year coupon bond, priced at 97. Annual coupons are $2, delivered at end of year. Three year coupon bond, priced at 96. Annual coupons are $3, delivered at the end of the year.

1. What is the coupon rate on the two-year coupon bond?

2. What is the current yield on the three-year coupon bond?

3. What is the yield-to-maturity of the three-year coupon bond?

4. Extract one year, two year, and three year spot rates from the bond data.

5. Using the spot rates, calculate the present value of $35 received in one year and $35 received in two years.

6. Using the spot rates, calculate the rate I should be able to lock in for a one year loan starting one year from now. Suppose now that you are a life insurance company projecting to pay benefits of $40 per year for the next 10 years to your policyholders. You are operating in an economy where the term structure of interest rates is completely flat at 4%, so that all spot rates are 4%.

7. Calculate the present value of your benefit obligations.

8. Calculate the duration of your benefit obligations.

9. Given your calculation above, if you were choosing a single type of bond from 1-year, 2-year, 3-year, 4-year, 5-year, 6-year, 7-year, 8-year, 9-year, and 10-year zero coupon bonds, which would serve you best from the perspective of asset-liability matching? In other words, if interest rates were to change, which bond’s price would move most closely with the present value of your obligations?

10. Calculate the percentage change in the value of your obligations if the interest rate were to drop from 4.0% to 3.9%.

11. Calculate the percentage change in the value of the bond you identified in (9) if the interest rate were to drop from 4.0% to 3.9%.

12. Calculate the percentage change in the value of a 1-year zero coupon bond if the interest rate were to drop from 4.0% to 3.9%.

13. (EXTRA CREDIT) If you were allowed to invest in more than one type of bond, could you provide a better match to your benefit obligations than you found in (9)? Propose a mix of bonds that would provide a better match, and verify that the percentage change in the value of the mix would more closely match the percentage change in obligation value in the interest rate scenario used in (10) through (12).

Find the future value of the following cash flow stream at a rate of 5%: Year 0: $0, Year 1: $400, Year 2 $300, Year 3 $250.

Using Excel. What is the present value of the following series of cash payments: $8,000 per year for four consecutive years starting one year from today, followed by annual cash payments that increase by 2% per year in perpetuity (i.e. cash payment in year 5 is $8,000*1.02, cash payment in year 6 is $8,000*1.022, etc.)? Assume the appropriate discount rate is 5%/year.