Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. hi, im supposed to make a net present value analys

Hi, Im supposed to make a net present value analysis for a diesel truck both...

60.1K

Verified Solution

Question

Finance

Hi, Im supposed to make a net present value analysis for a diesel truck both by hand and in excel. I can make up all the specifics myself, so I have chosen a discount rate of 10%, the truck is used for 10 years. The diesel truck is bought new for 100 000$ and the salvage value is 20 000$. The annual fuel cost is 10 000$.

My analysis so far:

Diesel truck:

NPV = (-$100,000) + (-$10,000 / 1.1) + ... + (-$10,000 / 1.1^9) + ($20,000 / 1.1^10)

NPV = -$72,415.47

Im supposed to do the NPV analysis in excel too, but when I plot in my equation the numbers are not the same as when I do it by hand.

This is what I type in Excel for the diesel truck:

Discount rate: 10%

Investment year 0: 100 000

Fuel cost year 1-9: 10 000 per year

Salvage value: 200 000

Cash flow

0: -100 00

1-9: 10 000

10: 20 000

The formula for NPV: NPV=(rate,value1,[value2],...)+investment

NPV= (10%,10 000,10 000, 10 000,,20 000)+ (-100 000)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

\"Bond Risk Management\" Please respond to the following: Given the Federal Reserve Board’s current and forward-looking position...

Finance
Q

Ms. Brown is a teacher in a first-grade classroom. The students are not wanting to listen...

Psychology
Q

Was President Roosevelt justified in ordering Executive Order 9066, which resulted in the internment of Japanese...

Psychology
Q

Answer true or false for each statement and give a logically valid explanation to support your...

Advance Math
Q

Solve for y.3y +12y=0If there is more than one solution, separate them with commas.If there...

Basic Math
Q

Part 0 5 LA Game consoles A poll surveyed 341 video gamers and 81 of...

Statistics
Q

Find all x ER satisfying the following inequalities X a x 3 2x 5 0...

Calculus
Q

Laverty Clinic plans to purchase a new centrifuge machine for its New York...

Accounting
Q

Sage Corp. carries an account in its general ledger called investments, which contained debits for...

Accounting
Q

I need assistance filling out this checkbook balance. ...

Accounting
Q

At December 31, 2020 Jersey Company had 200,000 shares of common stock and 10,000 shares...

Accounting
Q

50)Your portfolio returned10.7%last year, with a beta equal to1.4. The market return was8.2%,and the risk-free...

Finance