How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Johnmark1900 Your Own Question
Johnmark1900
Johnmark1900, Associate Degree
Category: Multiple Problems
Satisfied Customers: 841
Experience:  I am a qualified Chartered Accountant, working as finance manager for reputable organization
17235052
Type Your Multiple Problems Question Here...
Johnmark1900 is online now
A new question is answered every 9 seconds

1. Determine the cash inflows and outflows for each year. 2.

This answer was rated:

1. Determine the cash inflows and outflows for each year. 2. Evaluate the capital project by calculating the following metrics: a. net present value (NPV) b. internal rate of return (IRR) c. modified internal rate of return (MIRR) d. payback period e.discounted payback period 3.Indicate whether the project is acceptable, assuming Jiranna has a corporate policy of not accepting projects that take more than 3.5 years to pay for themselves, and assuming an 11% cost of capital. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Nurse Triage Salaries $523,800 $549,990 $577,490 $606,364 $636,682 $668,516 Forecasted ER Cost Reductions $400,000 $800,000 $848,000 $900,577 $955,512 $1,013,798 New IT Specialist's Salary $150,000 $154,500 $159,135 $163,909 $168,826 $173,891 Costs of Facility Renovations $30,000 $- $- $- $- $- Necessary Capital Equipment Purchases $117,000 $3,510 $3,510 $3,510 $3,510 $3,510 Net Cash Flow: Present Values of Net Cash Flows: Net Present Value: IRR: MIRR: Payback Period (# XXXXX): Discounted Payback Period (# XXXXX): Please show all work in the excel worksheet with formulas so I can understand why and how thanks
Hello,
could you please advise me your deadline.

Thanx
Customer: replied 3 years ago.

By Friday 16th

ok. ill back to you by your deadline
Customer: replied 3 years ago.

added to this please receive the

Customer: replied 3 years ago.

please receive case study two which is the excel spreadsheet, which is part of the question

Attachment: 2013-08-12_162159_capital_project_case_study_part_21.xlsx

Hello,

Please Click here for the solution. if you have any query please feel free to inquire, else give me positive rating

I SHALL BE GLAD TO ASSIST YOU IN FUTURE IF YOU LIKE MY WORK YOU CAN DIRECT YOUR POST TO ME BY TYPING "FOR JOHN" BEFORE YOUR POST.

 

Thanx

Johnmark1900 and other Multiple Problems Specialists are ready to help you