Question: please show me how to solve this in excel! Present-value comparison You are offered St 100 today. 55,000 in 9 years, or 535.000 in 29

please show me how to solve this in excel!

Present-value comparison You are offered St 100 today. 55,000 in 9 years, or 535.000 in 29 yours. Assuming that you can eam li percent on your money, which offer should you choose? a. What is the present value of 535,000 in 29 years counted at 8 percent interest rate? Round to the nearest cent) b. What is the present of 55.000 in 9 years discounted at percent interest rate? Round to the nearest cont) c. Which offer should you choose? (Select the best choice below O A Choose $35,000 in 29 years because its presenta is the highest O B. Choose 55.000 in years because its present Value is the highest OC Choose 51, 100 today because la presents the Highest

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 Finance Questions!

please solve all questions. thank you (Related to Checkpoint 5.6 ) (Solving for 0 ) At what annual interest rate, compounded annually, would $520 have to be investad for it to grow to $2. 00t 52 in...

AutoSave OFF H 5 + 5 = wa Douglas Case rev 9_7_21(2) (1) Home Insert Draw Design Layout References Mailings Review View Tell me Share Q Comments X LO Calibri (Bo... V 11 21 AaBbcDdEe AaBbCcDdEe AaBb...

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

Directions for Problem #4 in Excel The goal of this problem is to have you: Use Excel to generate the future value of each of the various investments made over the course of the 25 years. Use Excel...

I have completed part one of the assignment, I did all of the calculations. I would just like for someone to complete the assessment which is part two of the assignment and most importantly perform...

Please show the Excel Formulas & Abbreviations for Excel for the answers *** OO Time Value of Money Excel Assignment.xlsx GO E41 Y= fx L 75% Q- Search in Sheet A Home Layout Tables Charts SmartArt...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

1. A bank is paying interest at a 5% annual rate on deposits. If you invest 10,000 and the bank compounds interest daily (i.e., 365 times per year), which of the following shows how much you will...

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

I need help from a Financial expert who is very familiar with exchange rate exposure & payout policy.I will adjust the price as you suggest. For some reason I am not able to do it here. Please be...

Quantum Theory was put forward by A) Max Plank B) Maxwell C) Bohr D) De Broglie

If two persons incomes are unequal in each of five years, then their incomes over the entire five-year period must be unequal. Do you agree or disagree with this statement?

A defendant will not have to pay if he proves that the plaintiff contributed to the plaintiff's infuries or losses. a . False b Iruse clear my choice

Financial statements for Askew Industries for 2016 are shown below (in $000's): 2016 Income Statement Sales $ 9,000 Cost of goods sold (6,300) Gross profit 2,700 Operating expenses (2,000) Interest...