Capital Budgeting Finance Analysis Help With Solution

Instructions: leave all answers, whether in $, %, or years, to 2-decimal places.

PS: If you choose to do this Exercise in Excel, then all the following Capital Budgeting metrics have corresponding Excel formulas. You still want to make sure you know how to do them using your financial calculator during the Exam as access/prohibition to Excel is semester- and instructor-specific.

1. A project will cost $1.0 million. The company uses a 10% discount rate as a threshold for accepting capital projects. It is expected to have a 5 year life and returns (net of all costs and taxes) the following:

2015 Spring2
Year 1 Year 2 Year 3 Year 4 Year 5
$100,000 $200,000 $300,000 $400,000 $500,000

If you are using your financial calculator to do this Exercise, then show work is simply reporting the following cash flows marked “??”:
CF0 = ??, CF1 = ??, CF2 = ??, CF3 = ??, CF4 = ??, CF5 = ??

… then, you just report the calculator’s value marked “???” for the following functions; no need to show further work if your calculator have that function.

If your calculator do not have that function [e.g. the HP 12C doesn’t have these functions: PI; PB; DPB; MIRR; TV; NFV], then you might need to show more work with the intermediate calculations.

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Features

Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.

Relevancy
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.

Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.

100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services

a. Calculate the project’s Net Present Value (NPV)= $???

b. Calculate the Profitability Index (PI)= ???

(1) NPV of all POSITIVE CFs= ???
(2) NPV of all NEGATIVE CFs= ???

Then take (1) divided by (2) to get PI. Ignore negative sign in (2); PI is always positive.

c. Calculate the Internal Rate of Return (IRR)= ???%

d. Calculate the Payback Period (PB)= ??? years

e. Calculate the Discounted Payback Period (DPB) = ??? years

f. Assuming the funds can be invested at 5%, calculate the Terminal Value (TV) and the MIRR.

Terminal Value (TV)= $???
TV is the Net Future Value (NFV) of all [positive] cash inflows in the project]

Modified Internal Rate of Return (MIRR)= ???%

MET AD-632OL-1-2015 Spring2 / Financial Concepts

Product Code :Fin84

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary