Finance: Capital budgeting.
Not what you're looking for?
calculations must be shown in excel
1) Continuous Compounding: Compute the future value of $1,900 continuously compounded for:
a: 5 years at a stated annual interest rate of 12 percent.
b. 3 years at a stated annual interest rate of 10 percent.
c. 10 years at a stated annual interest rate of 5 percent.
d. 8 years at a stated annual interest rate of 7 percent.
________________________________________
2) NPV versus IRR: Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 14 percent.
Year Deepwater Fishing New Submarine Ride
0 -$750,000.00 -$2,100,000.00
1 310.00 1,2000,000.00
2 430,000.00 760,000.00
3 330,000.00 850,000.00
As a financial analyst for BRC, you are asked the following questions:
a. If your decision rule is to accept the project with the greater IRR, which project should you choose?
b. Because you are fully aware of the IRR rule's scale problem, you calculate the incremental IRR for the cash flows. Based on your computation, which project should you choose?
c. To be prudent, you compute the NPV for both projects. Which project should you choose? Is it consistent with the incremental IRR rule?
________________________________________
3) Calculating Project NPV: The Best Manufacturing Company is considering a new investment. Financial projections for the investment are tabulated here. The corporate tax rate is 34 percent. Assume all sales revenue is received in cash, all operating costs and income taxes are paid in cash, and all cash flows occur at the end of the year. All net working capital is recovered at the end of the project.
Year 0 Year 1 Year 2 Year 3 Year 4
Investment $16,000.00
Sales revenue $8,500.00 $9,000.00 $9,500.00 $7,000.00
Operating costs 1,900.00 2,000.00 2,200.00 1,700.00
Depreciation 4,000.00 4,000.00 4,000.00 4,000.00
Net working capital
spending 200.00 250.00 300.00 200.00 ?
a. Compute the incremental net income of the investment for each year.
b. Compute the incremental cash flows of the investment for each year.
c. Suppose the appropriate discount rate is 12 percent. What is the NPV of the project?
________________________________________
4) Bond Yields: Pembroke Co. wants to issue new 20-year bonds for some much needed expansion projects. The company currently has 10 percent coupon bonds on the market that sell for $1,063, make semiannual payments, and mature in 20 years. what coupon rate should the company set on its new bonds if it wants them to sell at par?
5) Accrued Interest: You purchase a bond with an invoice price of $1,090.00. The bond has a coupon rate of 8.4 percent, and there are 2 months to the next semiannual coupon date. What is the clean price of the bond?
Purchase this Solution
Solution Summary
The problem set deals with topics under capital budgeting and bond pricing.
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Introduction to Finance
This quiz test introductory finance topics.
Operations Management
This quiz tests a student's knowledge about Operations Management
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.