Question: You need to work on the mini-projects in Excel . Your final mini-project report should be well-organized and typed in a Word file. Are required

You need to work on the mini-projects in Excel. Your final mini-project report should be well-organized and typed in a Word file. Are required to submit both your Word report and Excel files to the instructor using the mini-project submission tool in Blackboard. The style and organization of the project accounts for 10 points.

Mini-Project 2: Capital Budgeting Analysis:

A firm is planning a new project that is projected to yield cash flows of -$515,000 in Year 1, $586,000 per year in Years 2 through 3, and $678,000 in Years 4 through 6, and $728,000 in Years 7 through 10. This investment will cost the company $2,780,000 today (initial outlay). We assume that the firm's cost of capital is 9.65%.

(1) Draw a time line to show the cash flows of the project.

(2) Compute payback period, net present value (NPV), profitability index (PI), internal rate of return (IRR), and modified internal rate of return (MIRR).

(3) Discuss whether the project should be taken.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 2 Payback 612 NPV 30697524 PI 111 IRR 1150 MIRR 1064 3 Yes the project should be under... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

6361ebb760ece_234133.pdf

180 KBs PDF File

6361ebb760ece_234133.docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Company overview - Susan's Consulting Company (SCC) has been in business for ten years and has experienced a significant turnover in the project management group, which has prompted senior leadership...

You need to work really .............. if you want to be a success.

How much should Abigail have in a savings account that is earning 4.25% compounded monthly, if he plans to withdraw $1,550 from this account at the end of every month for 11 years?

List 10 of five innovation traits/skills/competencies you need to work on. Five traits that you think that YOU personally need to enhance in order to create a more productive team. Name the skill...

Carolina Clinic is considering investing in new heart monitoring equipment. It has two options: Option A would have an initial lower cost but would require a significant expenditure for rebuilding...

Goltra Clinic is considering investing in new heart-monitoring equipment. It has two options: Option A would have an initial lower cost but would require a significant expenditure for rebuilding...

The net present value (NPV), profitability index (PI), and internal rate of return (IRR) methods are often employed in project valuation. Identify each of the following statements as true or false,...

Project Evaluation this is a comprehensive project evaluation problem bringing together much of what you have learned in this and previous chapters. Suppose you have been hired as a financial...

Using net present value (NPV) analysis, a manager can select those projects that will maximize the present value of future cash flows. NPV analysis is a powerful tool; however, surveys of current...

Jenny Jenks has researched the financial pros and cons of entering into an elite MBA program at her state university. The tuition and needed books for a masters program will have an upfront cost of...

Define the term net present value (NPV). What is each franchise's NPV?

Better Roads magazine reported the percentage of interstate and state-owned bridges that were structurally deficient or functionally obsolete (%SD/FO) for each U.S. state in 2003. (Percentages are...

You collected data from a normally distributed random process. You have a sample mean of 12 and a sample standard deviation of 3.5 using 25 measurements. Define a confidence interval that you are...

Find an integrating factor for the following equation. Use the notation mu ( x ) or mu ( y ) for the function ( x ) or ( y ) , respectively. ydx + ( x 4 x ) dy = 0

The voltage output signal in the Figure 2 was taken from acceleration measurement of cantilever beam using an accelerometer PCB Model 352C22 with sensitivity of 10 mV/g. Sketch the velocity and...

Help to make a question and answer that contains logical, programing, and physics(about electrical)

Describe the four building blocks of living cells. Discuss in detail the structure and biological functions of all of them. (Hint: Carbohydrates, Proteins, Lipids and Nucleic acids)

Corporate taxable income is based on an income statement that is similar to income statements prepared for financial reporting. It has Revenues less expenses equals income. How is the computation for...

Explain the structure of plasma membrane with respect to its form, organization and function. (hint: answer should include list of all the components and their functions/significance).

Probiotics are found in what? The ocean Rocks Clothing Supplements

Instruction: 1. The purpose of the three mini-projects is to strengthen your financial and quantitative analysis abilities. There are 200 points for the three mini-projects. You are required to show...

Instruction: 1. The purpose of the mini-projects is to strength your financial and quantitative analysis abilities. There are 200 points for the mini-projects. You can choose to work on any two of...

Question: FINC3304 (BUSINESS FINANCE) Final Project - Fall 2017 Instruction: You need to work on the mini-projects in Excel. Your final mini-project report should be well-organized and typed in a...

You need to work on the mini-projects in Excel . Your final mini-project report should be well-organized and typed in a Word file. Are required to submit both your Word report and Excel files to the...