Capital Expenditure - Monarch Corporation: Payback, IRR, NPV

Please see the attached file with 5 Problems on 1 spreadsheet for 1 company. Please solve and include instructions on how to solve.

Required:
A. Compute below the payback, IRR, and NPV. For NPV use the cost of capital as the discount rate. For part A assume the revenue is $200,000.
B. Copy the worksheet and solutions for part a to the worksheet part B, and redo the computations for a revenue of $250,000
C. Copy the worksheet and solutions for part a to the worksheet part C, and redo the computations for a revenue of $300,000. List the three NPVs and compute the expected NPV. Indicate whether monarch should do the project? If so why? If not why?
D. Take the IRRs calculated for the three different levels of revenue and compute the mean (expected return, standard deviation, and coefficient of variation given the probabilities for the three different IRRs. Remember you can list the IRRS based on how often they will occur, 3, 5, or 2 times out of 10.
F. Based on the results for part d, assume the discount rate to compute npv is based on the following:

See the attached file for complete solution. The text here may not be copied exactly as some of the symbols / tables may not print. Thanks

YEARS 0 1 2 3 4 5 6
INITIAL INVESTMENT (NO INCOME TAX AFFECTS)
COST OF THE EQUIPMENT NEEDED 194,000
WORKING CAPITAL NEEDS 50,000
TOTAL INITIAL INVESTMENT 244,000

ANNUAL OPERATING RECEIPTS
SALES 200,000 200,000 200,000 200,000 200,000 200,000
LESS COST OF GOODS SOLD 60,000 ...

Solution Summary

A comprehensive problem on capital investment. The solutions include four complete spreadsheets. The students can learn how to find relevant data from the problem to build financial models in Excel for decision-making.

(10-1)
NPV
A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%. What is the project's NPV (Hint: Begin by constructing a time line.)
(10-2)
IRR
Refer to Problem 10-1. What is the Project's IRR?
(10-3)
MIRR
Refer to Problem 10-1 What is t

Project SS costs $52,125, its expected net cash flows are $12,000 per year for 8 years, its WACC is 12%.
What is the project's NPV?
IRR?
MIRR?
Payback Period?
Discounted Payback Period?
(Show calculations)

Calculate the payback period and the NPV using the information below.
Cost of Capital = 13%
Initial Investment 100,000
Cash inflow 1 15,000
Cash inflow 2 20,000
Cash inflow 3 30,000
Cash inflow 4 35,000
Cash inflow 5 40,000
the IRR is closest to:

Project A has an internal rate of return of 15 percent. Project B has an IRR of 14 percent. Both projects have a cost of capital of 12 percent. Which of the following statements is most correct?
a. Both projects have a positive net present value.
b. Project A must have a higher NPV than Project B.
c. If the cost of capit

I know that the company should accept the project, but what about the time value of money? If you include this into the analysis would you still accept the project or reject it and why?

Question 1
Assume you have just been promoted junior financial manager of a company. You are very smart and are planning to be promoted in the next 2-2.5 years. An associate of your company shows you a project with the following cash flows.
End of Year Cash Flows
0 -$100,000
1 $40,000
2 $40,000
3 $40,000
4 $40,000
5 -$

1.Project K has a cost of $52,125, its expected net cash inflows are $12,000 per year for 8 years, and its cost of capital is 12 percent. (Hint: Begin by constructing a time line)
a. what is the projects payback period (to the closest years)?
b. what is the projects discounted payback period?
c. what is the projects npv?

I need help in understanding the cost of capital and how to figure it. Calculate the values for each project using the time value table- the cost of capital is 12%
1. NPV
2. IRR
3. Profitability index
4.Payback Period
Year Project A Project B
0 $-30,000 $-60,000
1 $ 10,000 $20,000
2 $ 10,000 $20,000
3 $ 10,000 $20,