Smolinski Company is considering an investment that will return a lump sum of $500,000 five years from now. What amount should Smolinski Company pay for this investment in order to earn a 4% return? Show calculations using all four methods: (a) formula, (b) factor Table PV.1, (c) financial calculator, and (d) Excel function PV.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter11: Capital Budgeting Decisions
Section: Chapter Questions
Problem 4EB: Assume a company is going to make an investment in a machine of $825,000 and the following are the...
icon
Related questions
Question

Please solve question 2 with excel function PV, thanks

Smolinski Company is considering an investment that will return a lump sum of $500,000 five years from now. What amount should Smolinski Company pay
for this investment in order to earn a 4% return? Show calculations using all four methods: (a) formula, (b) factor Table PV.1, (c) financial calculator, and (d) Excel function PV.
2)
Transcribed Image Text:Smolinski Company is considering an investment that will return a lump sum of $500,000 five years from now. What amount should Smolinski Company pay for this investment in order to earn a 4% return? Show calculations using all four methods: (a) formula, (b) factor Table PV.1, (c) financial calculator, and (d) Excel function PV. 2)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College