# Finance

Note: To receive credit, show work on all problems (It can be shown as Excel or financial calculator inputs as well) on either this sheet or in Excel. For instance, if solving for the FV of $ 100 at 6% over 5 years, one could demonstrate by listing the following: PV = -100, N=5, I=6 and FV =133.82 (which would be the answer).

1)Carson Trucking is considering whether to expand its regional service center in Mohab, UT. The expansion requires the expenditure of $10,000,000 on new service equipment and would generate annual net cash inflows from reduced costs of operations equal to $2,500,000 per year for each of the next eight years. In year eight the firm will also get back a cash flow equal to the salvage value of the equipment which is valued at $1 million. Thus, in year eight the investment cash inflow totals $3,500,000. Calculate the project’s NPV using each of the following discount rates:

a. 9%

b. 11%

c. 13%

d. 15%

2)Big Steve’s, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $100,000 and will generate net cash inflows of $18,000 per year for 10 years.

a. What is the project’s NPV using a discount rate of 10%? Should

the project be accepted? Why or why not?

b. What is the project’s NPV using a discount rate of 15%? Should the project be accepted? Why or why not?

c. What is this project’s internal rate of return? Should the project be accepted? Why or why not?

3) Jella Cosmetics is considering a project that costs $800,000 and is expected to last for 10 years and produce future cash flows of $175,000 per year. What is the project’s IRR?

4)Microwave Oven Programming, Inc. is considering the construction of a new plant. The plant will have an initial cash outlay of $7 million (CF0 = –$7 million), and will produce cash flows of $3 million at the end of year 1, $4 million at the end of year 2, and $2 million at the end of years 3 through 5. What is the internal rate of return on this new plant?

5)Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $1,950,000, and the project would generate cash flows of $450,000 per year for six years. The appropriate discount rate is 9 percent.

a.Calculate the net present value.

b.Calculate the profitability index.

c.Calculate the internal rate of return.

d. Should this project be accepted? Why or why not?

6)The Callaway Cattle Company is considering the construction of a new feed handling system for its feed lot in Abilene, Kansas. The new system will provide annual labor savings and reduced waste totaling $200,000 while the initial investment is only $500,000. Callaway’s management has used a simple payback method for evaluating new investments in the past but plans to calculate the discounted payback to analyze the investment. Where the appropriate discount rate for this type of project is 10 percent, what is the project’s discounted payback period?

7) The Bar-None Manufacturing Co. manufactures fence panels used in cattle feed lots throughout the Midwest. Bar-None’s management is considering three investment projects for next year but doesn’t want to make any investment that requires more than three years to recover the firm’s initial investment. The cash flows for the three projects (Project A, Project B, and Project C) are found below: (SHOW WORK/CALCULATIONS TO DEMONSTRATE ANSWER RATIONALE)

Year Project A Project B Project C

0 $(1,000) $(10,000) $(5,000)

1 600 5,000 1,000

2 300 3,000 1,000

3 200 3,000 2,000

4 100 3,000 2,000

5 500 3,000 2,000

a.Given Bar-None’s three-year payback period, which of the projects qualify for acceptance?

b.Rank the three projects using their payback period. Which project looks the best using this criterion?

c.If Bar-None uses a 10% discount rate to analyze projects, what is the discounted payback period for each of the three projects? If the firm still maintains its three-year payback policy for the discounted payback, which projects should the firm undertaken?

8)You are considering a project with an initial cash outlay of $80,000 and expected cash flows of $20,000 at the end of each year for six years. The discount rate for this project is 10%.

a.What are the project’s payback and discounted payback periods?

b.What is the project’s NPV?

c.What is the project’s PI?

d.What is the project’s IRR?

Answer rating (rated one time)

## Answer-100% correct solution from a CPA and CFA

body preview (3 words)

xxxx x go..,,

file1.xlsx preview (581 words)

# Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 1 | |||

xxxxxxx xxxx Outflow | xxxxxxxx | ||

Year | xxxxxx | Discounting xxx | PV |

0 | xxxxxxxxx | x | xxxxxxxxx |

1 | xxxxxxx | 0.9174 | 2293500 |

2 | xxxxxxx | 0.8417 | 2104250 |

x | xxxxxxx | xxxxxx | 1930500 |

4 | xxxxxxx | 0.7084 | 1771000 |

x | 2500000 | 0.6499 | xxxxxxx |

x | xxxxxxx | xxxxxx | xxxxxxxxxxxxxxxxxx |

7 | xxxxxxx | xxxxx | 1367500 |

8 | xxxxxxx | xxxxxx | xxxxxxx |

NPV | xxxxxxx | ||

xxxx | Amount | Discounting xxxx | PV |

0 | xxxxxxxxx | 1 | -10000000 |

x | xxxxxxx | 0.9009 | 2252250 |

x | 2500000 | xxxxxx | xxxxxxx |

x | xxxxxxx | 0.7312 | 1828000 |

4 | xxxxxxx | xxxxxx | 1646749.9999999998 |

x | 2500000 | xxxxxx | 1483500 |

x | xxxxxxx | 0.5346 | xxxxxxx |

x | 2500000 | 0.4816 | 1204000 |

x | xxxxxxx | xxxxxx | 1518650 |

xxx | xxxxxxx | ||

xxxx | Amount | xxxxxxxxxx xxxx | xx |

x | xxxxxxxxx | 1 | -10000000 |

x | xxxxxxx | xxxxxx | xxxxxxx |

2 | xxxxxxx | 0.7831 | 1957750 |

x | xxxxxxx | xxxxx | 1732499.9999999998 |

x | 2500000 | 0.6133 | xxxxxxx |

x | xxxxxxx | 0.5427 | 1356750 |

x | 2500000 | 0.4803 | xxxxxxx |

x | 2500000 | xxxxx | xxxxxxx |

8 | 3500000 | xxxxxx | 1316350 |

xxx | 2372100 | ||

Year | xxxxxx | xxxxxxxxxx xxxx | xx |

x | -10000000 | 1 | -10000000 |

x | xxxxxxx | xxxxxx | xxxxxxx |

x | xxxxxxx | xxxxxx | 1890250 |

3 | xxxxxxx | xxxxxx | 1643750 |

4 | xxxxxxx | 0.5717 | 1429250 |

5 | xxxxxxx | xxxxxx | 1242750 |

6 | xxxxxxx | xxxxxx | xxxxxxx |

x | 2500000 | 0.3759 | 939750 |

8 | 3500000 | xxxxxx | xxxxxxx |

xxx | xxxxxxx | ||

xxxxxxx 2 | |||

xxxx | Amount | xxxxxxxxxx @15% | PV |

0 | xxxxxxx | x | xxxxxxx |

x | xxxxx | 0.8695 | 15651 |

2 | xxxxx | 0.7561 | xxxxxxx |

x | xxxxx | 0.6575 | 11835 |

x | 18000 | 0.5717 | xxxxxxx |

5 | xxxxx | 0.4971 | xxxxxx |

6 | 18000 | 0.4323 | xxxxxx |

7 | xxxxx | 0.3759 | 6766.2 |

x | xxxxx | xxxxxx | 5884.2 |

9 | xxxxx | 0.2842 | xxxxxx |

xx | 18000 | 0.2471 | 4447.8 |

NPV | xxxxxxx | xx xxxx xxxxxxx xxx xxx xx xxxxxxxx because of negative xxx xx the project. | |

xxxx | xxxxxx | Discount - - - more text follows - - - |

Buy this answer | Try it before you buy it |

## the answer is explained in the simplest way and is attached

body preview (0 words)

file1.docx preview (999 words)

**xxxx Four Individual xxxxxxxx (1-8)**

*Note: xx receive credit, show work xx xxx problems (It can xx shown as Excel xx financial xxxxxxxxxx inputs xx xxxxx on xxxxxx xxxx sheet xx in Excel. xxx xxxxxxxxx xx xxxxxxx xxx xxx FV of $ xxx at xx over x years, xxx xxxxx demonstrate by listing the following: PV = xxxxx xxxx xxx xxx FV xxxxxxx xxxxxx would xx the answer*xx

**1)**xxxxxx Trucking is xxxxxxxxxxx whether xx xxxxxx xxx regional service xxxxxx xx xxxxxx xxx xxx xxxxxxxxx xxxxxxxx the expenditure xx xxxxxxxxxxx xx new xxxxxxx xxxxxxxxx and xxxxx xxxxxxxx xxxxxx xxx xxxx inflows xxxx xxxxxxx xxxxx xx xxxxxxxxxx xxxxx xx $2,500,000 xxx year xxx each of xxx next eight xxxxxx xx xxxx xxxxx xxx firm will also xxx back x cash xxxx equal xx xxx salvage xxxxx xx the equipment which is

- - - more text follows - - -

Buy this answer | Try it before you buy it |