FPC Replacement Project Analysis Worksheet

1. The equipment has a delivered cost of $205,000. An additional $4,000 is required to install and test the new system.

2. The new pumping system is classified by the IRS as 5-year property, although it has an 8-year estimated service life. For assets classified by the IRS as 5-year property, the Modified Accelerated Cost Recovery System (MACRS) permits the company to depreciate the asset over 6 years at the following rates: Year 1 = 20 percent, Year 2 = 32 percent, Year 3 = 19 percent, Year 4 = 12 percent, Year 5 = 11 percent, Year 6 = 6 percent. At the end of 8 years, the salvage value is expected to be around 5 percent of the original purchase price, so the best estimate of salvage value at the end of the equipment’s service life is $5,300, with removal costs of $1,200.

3. The existing pumping system was purchased at $45,000 eight years ago and has been depreciated on a straight-line basis over its economic life of 10 years. If the existing system is removed from the well and crated for pickup, it can be sold for $3,500 before tax. It will cost $1,000 to remove the system and crate it.

4. At the time of replacement, the firm will need to increase its net working capital requirements by $4,500 to support inventories.

5. The new pumping system offers lower maintenance costs and frees personnel who would otherwise have to monitor the system. In addition, it reduces product wastage because of a higher cooling efficiency. In total, it is estimated that the yearly savings will amount to $25,000 if the new pumping system is used.

6. The firm has its target debt ratio of 30 percent, and its cost of new debt is 10 percent. Its expected dividend per share next year, D1, is $2.00 with a future growth rate of 6 percent per year. The firm’s current stock price, P0, is $40.00. The firm uses its overall weighted average cost of capital in evaluating average risk projects, and the replacement project is perceived to be of average risk.

7. The firm’s federal-plus-state tax rate is 30 percent, and this rate is projected to remain fairly constant into the future.

 

QUESTIONS (Please show all your work either through Excel formulas/equations on the Cash Flow Estimation Worksheet or in separate tables at the bottom of your spreadsheet)

1. Compute the firm’s weighted average cost of capital given the info/data in the case. What other approaches/methods can be used to measure the firm’s cost of equity and thus its WACC? To that end, what additional info/data would you need? (Hint: A firm’s weighted average cost of capital is equal to ???????? = ????????(????????)(1 – t) + ????????????????, where ???????? and ???????? are the weights of debt and equity in the capital structure; ???????? and ???????? are the respective costs of debt and equity; and t is the corporate tax rate; Do no round up your WACC figure.)

2. Develop a capital budgeting schedule using the attached Cash Flow Estimation Worksheet (Excel spreadsheet) that should list all relevant cash flow items and amounts related to the replacement project over the 8-year expected life of the new pumping system.

 

3. Based on the capital budgeting schedule, evaluate the replacement project by computing NV, IRR, MIRR, and Payback Period. Would you recommend to accept or reject the replacement project based solely on your DCF analysis so far?

4. Before you make the final accept/reject decision, what other factors and approaches would you consider further? Discuss also how to PRACTICALLY take into account those factors and approaches in the capital budgeting decision process, whenever applicable

Sheet1

FALCONVILLE PUMP COMPANY – CASH FLOW ESTIMATION WORK WORKSHEET
Input Data New pump
Cost of NEW equipment 209000 Annual dep. of old equipment
Salvage value new equipment 10450 OLD equipment’s depreciable life left
Cost of old equipment Old equipment’s depreciated years
Depreciation of old equipment till date Annal cost savings
Salvage value of old equipment Removal cost of old equipment
Tax rate Removal cost of new equipment
WACC Net working capital requirement
t=0 t=1 t=2 t=3 t=4 t=5 t=6 t=7 t=8
I INVESTMENT OUTLAY
1
2
3
4
5
6
II OPERATING CASH FLOWS OVER THE PROJECT’S LIFE
7
8
9
10
11
12
III TERMINAL YEAR CASH FLOWS
13
14
15
16
17
IV NET CASH FLOWS
18
V RESULTS
NPV =
IRR =
MIRR =
Payback period =
DECISION BASED ON YOUR ANALYSIS:
ANSWERS TO QUESTIONS:
Q#1:
Q#2:
Q#3:
Q#4:

Sheet2

Sheet3

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Chapter 7 Exercise

Chapter 7  

1.You just graduated and accepted the job of your dreams. You will be making $4,000 a month and renting an apartment that will cost you $950 a month. You have no other debt. (Use the 28/36 rule from Chapter 5.)

 

2.You pick out a new car and the dealer is offering 0% interest for 60 months or a $4,000 cash-back bonus. Your negotiated price is $25,000. Your credit union is currently offering a special 3.5% for 60-month car loans.

 

a. What will be your monthly car payment if you accept the 0% interest offer? (Round your answer to 2 decimal places.)

 

 

b. What will be your monthly car payment if you accept the $4,000 cash-back bonus and finance the purchase at your credit union? (Round your answer to 2 decimal places.)

 

 

c. Should you accept the 0% interest offer or the cash-back bonus?

 

 

 

 

3.You are ready to purchase your first home. Your annual salary is $42,000. You have been able to save $15,000 for a down payment, and the only debt you currently owe is your student loan with a payment of $150 a month and your car payment of $350 a month. (Use the 28/36 rule from Chapter 5.)

 

a. Given your current situation, how much can you afford for a house payment?

 

 

b. If you no longer have a car payment, what monthly mortgage payment could you qualify for, given your outstanding credit history?

 

4.What is the loan payment on a 30-year, fixed-rate/fixed-term mortgage loan of $100,000 at 8%?

 

 

5.You are looking to finance your home. The bank is offering a three-year ARM (adjustable-rate mortgage) with an introductory rate of 3.5%. It has a 3% adjustment cap per adjustment period, with an 8% lifetime adjustment. The rate is 4% over the one-year LIBOR rate, which is currently 1.25%.

 

a. What will your interest rate be after three years if the LIBOR rate does not change? (Round your answer to 2 decimal places.)

 

 

b. In three years, what it the maximum interest rate you could be charged? (Round your answer to 2 decimal places.)

 

 

c-1. If the LIBOR increases 1% per year for the next 10 years, up to 11.25%, what is the maximum interest rate you will pay? (Round your answer to 2 decimal places.)

 

 

c-2. When will that maximum interest rate take effect?
   

 

 

 

 

6.Kim would like to purchase a new vehicle. Currently, she pays rent of $600 a month, credit card charges of $120 a month, and a student loan payment of $230 a month. Her gross monthly income is $4,000. Assume she wants to finance the vehicle for 3 years at 4 percent interest. What is the most she can afford as a car loan payment? Apply the standard 28/36 rule.

[removed]

 

 

7.You should expect a new vehicle to lose how much of its value within the first three years?

[removed]

[removed] 35 – 40%

20 – 25%

[removed] 25 – 30%
[removed] 15 – 20%
[removed] 10 – 15%

New vehicles generally depreciate 35% to 40% within the first three years.

 

 

 

 

 

 

 

 

8.Which of these statements is correct?

[removed]

[removed]
Auto leases tend to be better than purchases for individuals who drive more miles per year than the average person.

 

[removed]  

Lease payments tend to be lower than auto loan payments with the same duration.

[removed] Loan rates are generally lower for a used vehicle as compared to a new vehicle.
[removed] Individuals who lease vehicles tend to keep them longer than individuals who purchase vehicles.

 

You can usually terminate a vehicle lease early without incurring any penalty.

 

 
 

 

 

Lease payments tend to be lower than purchase payments because you are only paying for the depreciation during the lease period.

 

9.Which one of the following is a disadvantage of renting versus buying a house?

[removed]

[removed] increased free time
[removed] lower initial costs

 

[removed] potential annual payment increases
[removed] unexpected repair costs

capital gain if property values rise

 

 

10.Luis purchased a home costing $350,000 three years ago. He paid 20 percent down in cash and borrowed the remainder. Since that time, home values in his neighborhood have declined by 10 percent. Over the past three years, Luis has paid $4,900 on the principal balance of his mortgage. How much equity does he currently have in his home? Has his equity increased or decreased since he purchased the home?

[removed]

 

 

11.Private mortgage insurance is generally required if your down payment on a house is less than what percentage of the purchase price?

 

 

 

12.Theresa is concerned about lowering her monthly costs. Which of the following should she do when considering a home purchase to help address her concern regarding costs?

[removed]

[removed] avoid homes in high-risk insurance areas
[removed] look for a low-maintenance, small yard
[removed] locate a home close to her place of employment
[removed] compare property taxes from one area to another

 

13. An adjustable-rate mortgage has a 3-year adjustment period, an introductory rate of 5%, an adjustable rate equal to the LIBOR plus 4%, an adjustment period cap of 3%, a lifetime rate cap of 10%, and a floor of 4%. Assume this is the end of year 3 and the LIBOR is currently 5%. What interest rate will be charged in year 4?

 

 

14. Which one of the following fees that must be paid at closing, is stated correctly?

 

 

15. Home equity lines of credit:

[removed]

[removed] are fixed-rate, fixed-term loans.
[removed] charge interest that is non-deductible for tax purposes.
[removed] generally charge higher rates than typical credit cards.

are adjustable-rate loans.

are unsecured debts.

 

 

 

 

16.You had a $2,300 balance last month after your payment on your credit card. You charged one pair of shoes on the 10th for $230. Your card has a minimum finance charge fee of $5 per month and an APR of 12%. What is your total balance due this period if the card’s fees are calculated via the adjusted balance method?

 

 

17.You have a credit card balance of $44. You have made no charges this past month. Your card has a minimum finance charge fee of $5 per month and an APR of 9%. What is your total balance due this period if the card’s fees are calculated via the average daily balance method? (Do not round intermediate calculations.)

 

 

 
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Developing Strategic KPIs Assignment

Developing Strategic KPIs Assignment: The Key to Successful Marketing Metrics

 

MSM Program 2020

 

 

For strong, successful marketing, you need to connect your goals with the outcomes of various marketing activities so that you can measure your degree of success on a regular basis. To accomplish this, you need to design measurable objectives and specific key performance indicators (KPIs) that will help you to (1) stay on track with your marketing plans and (2) inform you if you are achieving your goals in the timeframe you desire.

 

Assignment – Part A – Developing KPIs

 

For a company in your area of expertise or interest (it could be your current employer), consider several business/marketing needs, problems, and/or pain-points. (NOTE: The scenario for this assignment cannot be associated to your Marketing Plan assignment.) Develop a set of interconnected goals, objectives, and KPIs that will help the company achieve success. Specifically, please deliver the following:

· Write a short description (1-2 paragraphs) of the industry, the company, and some pertinent marketing needs, problems, and/or pain-points.

· List and explain 2 or more higher-level conceptual goals (and how the achievement of these goals would help the company be successful). To mirror what we often find in the marketplace, these goals should be somewhat ambiguous.

· List and detail 2 or more SMART objectives for each goal that help to define that goal.

· List and detail 2 or more KPIs for each objective that you list (some KPIs may be direct measurements and others may be indirect measurements).

· Create a visual that illustrates how the KPIs, objectives, and goals are interrelated.

· Create a timeline (weekly for 2 months; monthly or quarterly for 12 months) showing periodic performance expectations for each objective and KPI, as well as when particular KPIs will be measured, observed, and assessed. (Consider whether and how your KPIs need to change each period to meet the final objectives.)

 

Assignment – Part B – Testing KPI Integrity

 

One potential problem with “managing by KPIs” is that some KPIs can be manipulated in a way that KPI targets are achieved even though the ultimate objectives and goals are not. Consider all of your KPIs, objectives, and goals and then come up with at least one scenario in which employees or outsourced staff could reach a particular KPI target in a way that does not reach the objectives and/or goals. Write a several paragraphs explaining how this could occur and what you might be able to do to prevent it.

 

 

Assignment – Part C – Reflection Questions

 

Answer each of the following questions in a separate paragraph and use numbers or headings to identify them.

1. How did the exercise of connecting KPIs to objectives, objectives to goals, and goals to success influence how you think about marketing planning?

2. How would you determine the balance between measuring a multitude of performance details versus allowing your management teams to have flexibility in reaching objectives and goals?

3. How can this exercise help you with reaching your own personal and professional goals? (Give at least two detailed examples.)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Cases In Financial Decision-Marking

complete the Q3 and Q4 and i have presentation for this case,do the PowerPoint use key words, and Briefly summarize these two questions and attach a brief speech

Case Study:

Betting on Gold Using a Futures-Based Gold ETF

Suggested Assignment Questions

:

1.

How do gold futures contracts work?  What are the primary differences between futures

and forward contracts?

2.

Suppose Michelson took a long position (as a speculator) on the December 2012 gold

futures contract on 9/20/2012 and closed it on 10/19/2012.  Would Michelson have

lost money or made a profit during that period, and would he have received a margin

call?  Hint: Compute (mark to market) the daily gains/losses over the period.

3.

How are gold futures determined?  For example, can you make sense of the Dec-12 (GCZ12)

futures price?  Hint:  Apply the spot-futures parity equation.

4.

Gold futures prices are typically higher for longer maturities:  Does that mean that gold

prices are expected to rise?  Hint:  Use case Exhibit 6 data to support your argument.

5.

What drives futures gold futures prices outside of demand?

6.

Looking at case Exhibit 3, explain why the futures-based gold ETF (DGL) has a slippage

in returns compared to the physical-based gold ETF (GLD) or gold spot prices?  Why is

the slippage less than the futures-based oil ETF (USO) relative to crude oil spot prices

in Exhibit 2?

7.

Examine the period from 6/2/2008 to 10/19/2012.  Assume the DGL follows the roll

Schedule in case Exhibit 12 for DBLCI-OY Gold.  The GC futures contracts are listed in

case Exhibit 13.  How much did the roll yield contribute to the DGL returns?

8.

In which ETF would you recommend Michelson invest in order to get exposure to gold:

The DGL or GLD?  Or would you recommend another option altogether?  Explain your

reasoning with support point

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"