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.

Can you simplify this please.

Required information [The following information applies to the questions displayed below.] Consider the following narrative describing the process of filling a customer's order at a Starbucks branch: Identify the start and end events and the activities in the following narrative, and then draw the business process model using BPMN: the Starbucks customer entered the drive-through lane and stopped to review the menu. He then ordered a Venti coffee of the day and a blueberry muffin from the barista. The barista recorded the order in the cash register. While the customer drove to the window, the barista filled a Venti cup with coffee, put a lid on it, and retrieved the muffin from the pastry case and placed it in a bag. The barista handed the bag with the muffin and the hot coffee to the customer. The customer has an option to pay with cash, credit card, or Starbucks gift card. The customer paid with a gift card. The barista recorded the payment and returned the card along with the…

Is there an excel table showing how to use functions?