Question: How do I enter NPV in Excel for the function over 4 years? Uprfont cost was $50,000, then total savings $79,000 and total costs with

How do I enter NPV in Excel for the function over 4 years?

Uprfont cost was $50,000, then total savings $79,000 and total costs with upfront =$64,800

So total cash in/out is $14,200

How do I enter that in excel for the NPV formula to work?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

BUSN1002 Practice Question 1 - Statement of Cash Flows The Comparative Balance Sheet of Wilson Ltd as at 30 June 2017 and 2018 are presented below, together with the Income Statement for the Year...

Q:

Introduction: This exercise is worth 15 points. It provides you with an opportunity to practice managing a zero-based budget using practical scenarios. Assume, with limited work experience and a...

Q:

Please help with the assignment is due in an hour (2) Complete design and simulati x C Search Textbook Solutions | Ches X WhatsApp 2020_ACC300_S3BCTO2_FI_ACTIV X + c File...

Q:

CASE 16 Nucor Corporation in 2014: Combating Low-Cost Foreign Imports and Depressed Market Demand for Steel Products Arthur A. Thompson The University of Alabama n 2014, Nucor Corporation, with a...

Q:

CASE 16 Nucor Corporation in 2014: Combating Low-Cost Foreign Imports and Depressed Market Demand for Steel Products Arthur A. Thompson The University of Alabama n 2014, Nucor Corporation, with a...

Q:

can someone else help me for that ? i need solution or detail how can you do it ? FINA3313-005 Homework 3 Fall 2015 Chapter 08 Net Present Value and Other Investment Criteria True / False Questions...

Q:

I need to answer for two questions, one is about the manufacturing account, and the other one is about cash budget. Thanks! 11 Additional information CL pic is a manufacturing business. Goods are...

Q:

I need to answer for two questions, one is about the manufacturing account, and the other one is about cash budget. Thanks! 11 Additional information CL pic is a manufacturing business. Goods are...

Q:

I need the answers or instructions on how to get the answers for all of problem three and the unfinished part of problem 4. This class is financial modeling, must use the formulas by tagging them to...

Q:

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

Q:

Oscar works as a salesperson for a software company, X-Tech, which offers him a fixed salary, commissions and several benefits. He is having a hard time understanding which part of his compensation...

Q:

Uhura Company has decided to expand its operations. The bookkeeper recently completed the balance sheet presented below in order to obtain additional funds for expansion. Uhura Company Balance Sheet...

Q:

The three cash flows that must be considered in the capital budgeting process include the _ investment, _ cash flows, and the terminal _ net flows.

Q:

Jane Noonan is the bookkeeper for Wilson Company, Inc. Jane has been trying to get the company??s balance sheet to balance. She finally got it to balance, but she still isn??t sure that it is...

Q:

Earn Hart Corporation has outstanding 3,000,000 shares of common stock of a par value of $10 each. The balance in its retained earnings account at January 1, 2010, was $24,000,000, and it then had...

Q:

One-dimensional, steady-state conduction with uniform internal energy generation occurs in a plane wall with a thickness of 50 mm and a constant thermal conductivity of 5 W/m K. For these...

Q:

Consider four mutually exclusive alternatives: The analysis period is 8 years. At the end of 2, 4, and 6 years Alt A will have an identical replacement. Alternative B will have a single identical...

Q:

A firm is considering two alternatives: At the end of 4 years, another B may be purchased with the same cost, benefits, and so forth. If the MARR is 10%, which alternative should be selected? A...

Q:

What do many organizations use to schedule and coordinate changes for information systems? Question 2 3 options: A . Impact analysis B . Backout plans C . Maintenance windows D . Version control

Q:

5. Which metaphors do you mainly use when talking about organizations and companies? What do these metaphors express about an organization or a company? Are there other metaphors that may be more...

Q:

4. Using the same examples you gave in question 3, try to identify circular sequences, i.e. A affects B, but B also affects A.

Q:

6. Give three examples that nothing (doing nothing) can function as a cause.