Capital Budgeting Decision Models

Get a 10% discount on an order above
Use the following coupon code :
Get10

Order a Similar Paper Order a Different Paper

Resources: Microsoft® Excel®, Capital Budgeting Decision Models Template

Calculate the following problems using Microsoft® Excel®:

  • Calculate the NPV for each project and determine which project should be accepted.

Project A Project B Project C Project D   Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00)   Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00   Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00   Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00   Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00   Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00   Rate 7% 10% 13% 18%

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  • Your company is considering three independent projects. Given the following cash flow information, calculate the payback period for each. If your company requires a three-year payback before an investment can be accepted, which project(s) would be accepted?

Project D Project E Project F   Cost 205,000.00 179,000.00 110,000.00   Inflow year 1 53,000.00 51,000.00 25,000.00   Inflow year 2 50,000.00 87,000.00 55,000.00   Inflow year 3 48,000.00 41,000.00 21,000.00   Inflow year 4 30,000.00 52,000.00 9,000.00   Inflow year 5 24,000.00 40,000.00 35,000.00

  • Using market value and book value (separately), find the adjusted WACC, using 30% tax rate.

Component Balance Sheet Value Market Value Cost of Capital   Debt 5,000,000.00 6,850,000.00 8%   Preferred Stock 4,000,000.00 2,200,00.00 10%   Common Stock 2,000,000.00 5,600,000.00 13%

  • attachment

    capitalbudgetingweek4fin.xlsx

Essay Writing Service at $11/page: Your Personal Essay Writer

Looking to get your papers done? We have worked on a similar assignment and our student scored better and met their deadline. All our tasks are done from scratch, well researched and 100% unique, so entrust us with your assignment and I guarantee you will like our services and even engage us for your future tasks. Click below button to submit your specifications and get order quote

Get started