Question

IF USING EXCEL FOR CALCULATIONS, INDICATE FACTORS USED FOR ALL ARGUMENTS AL L PERCENTAGES AND DOLLAR AMOUNTS SHOULD BE EXTENDED 2 DECIMALS 1. Your uncle offers you a cholce of $115,000 in 10 years or $52,000 today. If the money is discounted at 9%, which should you choose? 115000 in 10 FV= 115000 2. If you invest $9,500 per period for the following number of periods, how much would you have? A. 10 years at 10% B. 15 years at 9%
media%2Ff97%2Ff9752d67-4238-435b-be27-4a
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.

value of future money today

=115000/(1+9%)^10

=48577 which is lesser than 52000

so choose 52000 today

the above is answer

we do only one question based on Chegg rule.

Add a comment
Know the answer?
Add Answer to:
IF USING EXCEL FOR CALCULATIONS, INDICATE FACTORS USED FOR ALL ARGUMENTS" AL L PERCENTAGES AND DOLLAR...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but...

    deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but only in EXCEL CHAPTER 2 The Time Value of Money 47 5. (PV single cash flow) Your friend comes to you with a $2,000 post-dated check. The check is due 2 years from today. If the interest rate is 5%, what is the value of the check today? 6. (PV single cash flow, finding r) If you deposit $25,000 today, Union Bank offers to...

  • Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of...

    Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of Money Functions (demonstrated in class) as well as cell references to receive FULL credit. Make sure to set up the data for each problem so you can "point" to the appropriate values in your formulas. Each problem is worth 20 points. This assignment must be completed INDIVIDUALLY. THIS IS NOT A GROUP ASSIGNMENT. The file you submit in CANVAS must be one that YOU...

  • Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...

    Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...

  • I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...

    I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...

  • Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs...

    Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs (ie. N, PV, etc.) to get partial credit. 1. How much would you pay for the right to receive $12,000 at the end of 15 years if you can earn a 15% return on a real estate investment with similar risk? 2. What constant amount invested at the end of each year at a 10% annual interest rate will be worth $20,000 at the...

  • avakis FN 305-Foundations of Finandal Management Soring 2019- Final Exam Student: Directions: Complete all a...

    avakis FN 305-Foundations of Finandal Management Soring 2019- Final Exam Student: Directions: Complete all answers on separate paper. Use pencil for all problems. Show the formula first and can check your answer with the financial calculator, but do not just write down a number you got from your calculator. The problems count 23 points each and the discusslon question counts 39 points for a total of 200 points. Use a pen to write the discussion question. (Assume 365 days per...

  • ***PLEASE ANSWER ALL QUESTIONS IN DETAIL, SHOWING ALL WORK AND CALCULATIONS FOR A THUMBS UP! THANKS...

    ***PLEASE ANSWER ALL QUESTIONS IN DETAIL, SHOWING ALL WORK AND CALCULATIONS FOR A THUMBS UP! THANKS A TON! Buy vs Lease Angelo Rossi opened his little “upscale” Italian restaurant almost 25 years ago in the heart of New York City. His specialty was the freshly baked bread oozing with homemade garlic butter and of course, the delicious varieties of pasta and lasagna. The ambience and aroma were simply out of this world and kept bringing the customers back for more....

  • Please show all work. Thank you I greatly appreciate your help! 4 Lexy Halliday graduated four...

    Please show all work. Thank you I greatly appreciate your help! 4 Lexy Halliday graduated four years ago with degrees in accounting and finance. She has been employed in the finance 5 department at Thorvaldsen Conglomerated (TC) since graduation. She is satisfied with her current job, but is 5considering an MBA degree to increase her skills and her advancement prospects. She has examined a number of MBA schools. She has narrowed her choices to 1) staying in her current job,...

  • 1. How does Lexy’s age affect her decision to get an MBA?               A...

    1. How does Lexy’s age affect her decision to get an MBA?               A Aceto, Frank BUS 622 Week 3 Case Study Template F19- Excel AutoSave Off Share Review File Home Insert Page Layout Formulas Data View Help Tell me what you want to do AutoSum As 12A A Wrap Text Calibri General Fill Paste в I U Conditional Format as Insert Delete Format Sort & Find & - A 0 00 00 0 | Merge & Center...

  • this is all the information given Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple...

    this is all the information given Personal Financial Planning Mini-Case Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet reached their peak earning years. Jeff is a general manager of a jewelry manufacturer in Providence, RI while Mary teaches at the local elementary school in the town of Tiverton, RI. The family needs both incomes to meet their...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT