StudentShare solutions

# Capital Budgeting: Case Study (Answering questions) - Math Problem Example

## Extract of sampleCapital Budgeting: Case Study (Answering questions)

Overall, there is a large difference between NPVs of the two projects while there is a smaller difference between their IRRs. Hence, Project ‘p’ should be selected over Project ‘q’.
Moreover, IRR ranking is misleading here because the base investment (initial cash outflow) in the two projects is not the same. The cash outflow in Project ‘p’ (\$200) is twice that of project ‘q’ (\$100). Hence, it would not be appropriate to compare the two projects on IRR basis.

2. Let ‘S’ be the periodic saving, ‘i’ be the interest rate, ‘P’ be the annual payments to be ensured, ‘n’ be the number of years for which savings are done and ‘N’ be the number of years for which payments are to be ensured. According to the given data,
S has to be calculated
i=4%
P=\$30,000
n=20 years
N=15 years
Now, Future value of all savings at the end of 65 years= Present Value of all payments at the end of 65 years
i.e. S[(1+i)^n-1]/i = P (1-(1/(1+i)^N))/i
i.e. S[(1+.04)^20-1]/.04 = 30000 (1-(1/(1+.04)^15))/.04
i.e. S= \$11,201.25
Hence, the annual savings must be \$11,201.

3. Table 3.1 depicts the Interest paid, Principal Paid and Principal Balance at the end of first 10 years. Here, Interest paid is calculated as 10% of principal balance in the previous year. The Principal paid is calculated as the difference of Yearly Installment and Interest

Table 3.1: Yearly Installment Plan at 10% rate of interest throughout
Year Interest paid Principal paid Principal balance
0 0 0 200000
...
The yearly installment can be calculated by using formula for Present value or ‘pmt’ function in excel. It comes out as \$21,215. The principal balance at the end of 1 year comes out as \$198,784 and at the end of 10 years as \$180,622. If mortgage rates drop to 8%, the yearly installments after 4th year are calculated using principal balance at the end of 4th year. This comes out as \$17,979. Table 3.2 depicts Table 3.2: Yearly Installment Plan at 10% rate of interest till 4th year and 8% thereafter Year Interest paid Principal paid Principal balance 0 0 0 200000 1 20000 1,215.85 198784.1503 2 19878.41503 1,337.43 197446.7157 3 19744.67157 1,471.18 195975.5377 4 19597.55377 1,618.30 194357.2418 5 15548.57934 2,430.85 191926.3911 6 15354.11129 2,625.32 189301.0724 7 15144.08579 2,835.34 186465.7282 8 14917.25826 3,062.17 183403.5565 9 14672.28452 3,307.15 180096.411 these changes. Now, if \$3000 is paid to refinance this change, the value of Net Present Value of cash outflow at the end of 4th year is given by the sum of Future value of installments up till 4th year at 10%, Present value of installments from 4th year to 9th year at 8% and \$ 3000. This is equal to \$173,249. If \$ 3000 is not paid and rather invested in CD at 6% return, the value of Net Present Value of cash outflow at the end of 4th year is given by [Future value of installments up till 4th year at 10% + Present value of installments from 4th year to 9th year at 10% - \$ 3000[(1.06)^5-1]. This is equal to \$177,872. Hence, refinancing the mortgage is a better option as the NPV of net cash outflows is lower. It is assumed here that after the 9th year, the house is sold or the returns from it are similar in both options. 4. The efficiency of the compensation plan is dependent upon the expected revenue of ...Show more

## Summary

1. From the given data, it can be seen that Project ‘p’ has a higher NPV as compared to Project ‘q’. Hence, if NPV is chosen as the criterion, Project ‘p’ must be preferred. However, it is also seen that Project ‘q’ has a higher IRR.
Author : wstoltenberg
Save Your Time for More Important Things
Let us write or edit the math problem on your topic
"Capital Budgeting: Math Case Study (Answering questions)"
with a personal 20% discount.
Grab the best paper

### Related Essays

Capital Budgeting: Cash flow projections of Bauer Industries
As the capital expenditure is marked in negative, the NPV is computed by adding the Capital Expenditure to the summation of the PVs of the ten cash flows. The deduction of the capital expenditure value from the summation of the above mentioned PVs gives us the project’s NPV which is equal to 57.
3 pages (750 words) Math Problem
Revenue Math Problem
The property information indicates that this hotel is very distinct from its competitors. It has a superb architecture that if properly highlighted will not only woe customers but provide a opportunity for a higher average daily rate (ADR) than its competitors.
3 pages (750 words) Math Problem
Algebra Math Problem
Application: Matthew would like to put up a small coffee-bean store selling two special varieties of coffee – Arabica(M) and Robusta(H). He estimates obtaining profit from each kg of Arabica(M) worth \$10.50 and from each kg of Robusta(H) costing \$9.25. If he desires to have 2500 kgs of bean-mixture sold for \$9.74 per kg, how much of each kind must be present in the mixture?
6 pages (1500 words) Math Problem
College Math Math Problem
An independent variable is the number of years after 1960. c) Both models have rather close predictions. In order to validate their predictive power it is necessary to check the predicted values vs. the actual values. For this purpose I used the actual MSW data for 2003 provided by the United States Environmental Protection Agency (EPA)1.
2 pages (500 words) Math Problem
MATH Math Problem
(a) Prepare an income statement and an owner's equity statement for the year. The owner did not make any new investments during the year. (If there is a loss, put amount in parenthesis in the income statement. If there is a loss, enter the amount as a positive number on the owner's equity statement.
1 pages (250 words) Math Problem
Math Problem
3 pages (750 words) Math Problem
College Math Master Math Problem
Here it is given that the tires are equally durable(i.e. identical in terms of quality and thickness). Also we assume here that the roads on which the two cars travel and other conditions are identical so that the friction offered is practically the same and that the cars have more or less the same weight(generally the cars with the larger wheels have more weight and hence offer more burden on their wheels).
2 pages (500 words) Math Problem
Math hw4
According to Porter, differentiation is one of the winning strategies in the market which a company can utilize in order to compete with other players by stressing product attributes that sets it apart from its competitors. Cost leadership strategy entails pricing at par or even below the industry average in order to gain market share but also delivery of a certain level of product or service quality.
2 pages (500 words) Math Problem
College Math
I was puzzled to find out that the vectors connecting the same two points (let's say QR and RQ) are not equivalent. How can it happen It seems so logical to assume that if two endpoints are the same, the segment between them is the same also. Can somebody help me with this issue
2 pages (500 words) Math Problem
Corporate Finance Math Problem
The balance sheet showed that the assets of the company increased with the despite of increasing sales. Cash decreased because the company sold more of their products on credit rather than on cash, which can be observed by the growing number of Account receivables which manifested a figure of \$0.632 million FY 2007, which were \$0.35 million a year before.
8 pages (2000 words) Math Problem
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger