All downloads offered at 30% Off. Promo code applied automatically during checkout.

FIN419 Week4 Capital Budgeting Decision Models

by adminin on February 28, 2018
Previous $10.00

Choose Your Desired Option(s)

Previous $10.00

DOC720R Day 3, QNT351 Week 5, QNT351 Week 4, QNT351 Week 3, QNT351 Week 2, ENT588 Week4, FIN571 Week4, FIN571 Week3, FIN571 Week1, FIN486 Week5, FIN486 Week 4, FIN486 Week 3, FIN486 Week3, FIN486 Week2, FIN486 Week1, BIS221T Week3, QNT562 Week5, CPMGT300 Week 3, QNT275 Week5, QNT275 Week4, QNT275 Week3, QNT275 Week2, ACC561 Week4, QRB501 Week6, QRB501 Week5, QRB501 Week3, QNT561 Week4, QNT561 Week5, international finance, qnt561 week5, qnt561 week4, doc700 week5, cash flows, stock, financial, ACC/290 Week3, FIN419 Week2, FIN419 Week3, FIN419 Week 3, FIN419 Week4, FIN419 Week 4, FIN419 Week5, ACC291 Week 1, ACC291 Week2, ACC291 Week3, BIS221 Week3, ACC460 Week4, ACC460 Week5 ch 16, CPMGT303 Week 2, FP100 Week1, FP100 Week3, DAT565 Week 5

FIN419 Week 4 Capital Structure

FIN419 Week 4: Purpose of Assignment 

The purpose of this assignment is to allow the students to become familiar with and practice the measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital (WACC) using Microsoft® Excel®. 

Assignment Steps 

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 AProject BProject CProject D
Inital Outlay(105,000.000)(99,000.00)(110,000.00)(85,000.00)
Inflow year 153,000.0051,000.0025,000.0045,000.00
Inflow year 250,000.0047,000.0055,000.0050,000.00
Inflow year 348,000.0041,000.0015,000.0030,000.00
Inflow year 430,000.0052,000.0021,000.0062,000.00
Inflow year 535,000.0040,000.0035,000.0068,000.00
Rate7%10%13%18%
  • 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 DProject EProject F
Cost205,000.00179,000.00110,000.00
Inflow year 153,000.0051,000.0025,000.00
Inflow year 250,000.0087,000.0055,000.00
Inflow year 348,000.0041,000.0021,000.00
Inflow year 430,000.0052,000.009,000.00
Inflow year 524,000.0040,000.0035,000.00
  • Using market value and book value (separately), find the adjusted WACC, using 30% tax rate.
ComponentBalance Sheet ValueMarket ValueCost of Capital
Debt5,000,000.006,850,000.008%
Preferred Stock4,000,000.002,200,00.0010%
Common Stock2,000,000.005,600,000.0013%

 

 

This assignment contains a Microsoft Excel spreadsheet.

 

Click HERE for more FIN419 weeks.

If you would like to order an original assignment, please contact admin@uop-assignments.com. Thank you.

 

Previous $10.00
Previous $10.00

0 Sale

Share Now!

Release Information

  • Price
    :

    Previous $10.00 $7.00

  • Released
    :

    February 28, 2018

  • Last Updated
    :

    July 30, 2019