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 DInital Outlay(105,000.000)(99,000.00)(110,000.00)(85,000.00)Inflow year 153,000.0051,000.0025,000.0045,000.00Inflow year 250,000.0047,000.0055,000.0050,000.00Inflow year 348,000.0041,000.0015,000.0030,000.00Inflow year 430,000.0052,000.0021,000.0062,000.00Inflow year 535,000.0040,000.0035,000.0068,000.00Rate7%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 FCost205,000.00179,000.00110,000.00Inflow year 153,000.0051,000.0025,000.00Inflow year 250,000.0087,000.0055,000.00Inflow year 348,000.0041,000.0021,000.00Inflow year 430,000.0052,000.009,000.00Inflow year 524,000.0040,000.0035,000.00Using market value and book value (separately), find the adjusted WACC, using 30% tax rate.ComponentBalance Sheet ValueMarket ValueCost of CapitalDebt5,000,000.006,850,000.008%Preferred Stock4,000,000.002,200,00.0010%Common Stock2,000,000.005,600,000.0013%Click the Assignment Files tab to submit your assignment.

• CopyofFIN419_r6_wk4_Capital_Budgeting_Decision_Models_Template.xlsx

Need Help with Your Assignment? Let us Help you

Place Your Order

We guarantee you the following if you order your paper with us

High Quality Papers

All papers are written by ENL (US, UK, AUSTRALIA) writers with vast experience in the field. We perform a quality assessment on all orders before submitting them.

Timely Delivery

Do you have an urgent order?  We have more than enough writers who will ensure that your order is delivered on time. 

100% Original

We provide plagiarism reports for all our custom written papers. All papers are written from scratch.

24/7 Customer Support

Contact us anytime, any day, via any means if you need any help. You can use the Live Chat, email, or our provided phone number anytime.

Confidential and Secure

We will not disclose the nature of our services or any information you provide to a third party.

Stressed? We got you covered

Money-Back Guarantee

Get your money back if your paper is not delivered on time or if your instructions are not followed.

We Guarantee the Best Grades

Get a Professional Answer