Samantha wants to take the next four years off work to travel around the world. She estimates her annualcash needs at $30,000 (if she needs more, she'll work odd jobs). Samantha believes she can invest hersavings at 8% until she depletes her funds.Use the blue shaded areas on the ENTERANSWERS tab for inputs.Always use cell references and formulas where appropriate to receive full credit. If you copy/paste fromthe Instruction tab you will be marked wrong.Requirements1 How much money does Samantha need now to fund her travels.a. Use a single Excel formula function PV and be sure to enter any payment amount with a minus signor parenthesis.2 After checking with a number of banks, Samantha learns she'll be able to invest her funds only at 6%.How much does she need now to fund her travels?a. Use a single Excel formula function PV and be sure to enter any payment amount with a minus signor parenthesis. 1. How much money does Samantha need now to fund her travels.(Always use cell references and formulas where appropriate to receive full credit. If youcopy/paste from the Instruction tab you will be marked wrong.)Money needed now to fund her travels2. After checking with a number of banks, Samantha learns she'll be able to invest herfunds only at 6%. How much does she need now to fund her travels?|(Always use cell references and formulas where appropriate to receive full credit. If youcopy/paste from the Instruction tab you will be marked wrong.)Money needed now to fund her travels

Present value of annuity is the current value of the future payments that are calculated using the…

Answered: Samantha wants to take the next four…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Patricia deposits $1,000 into an account that earns 4.9% compounded monthly and plans to make monthly payments of $170 into the account. How long must she invest until she has $35,000? N=? I= 4.9 PV=1,000 PMT=170 FV= 35,000 P/Y=12 C/Y=12 Missing Variable Value __________________ Context Sentence:
Use the given spreadsheet formulas for each question below. Write down your calculations and/or what you type into excel to show your work, as well as the final answer. Answer each question with a complete sentence response. No credit will be given if the Excel/sheets syntax is not provided. Round your answer to the nearest cent. Q. Jayden borrows $10500 from his grandmother for 4 years. Jayden’s grandmother gives Jayden a simple annual interest loan at 4.5% interest. How much will Jayden need to repay grandma in interest? How much in total will Jayden pay?
Tamika Harms needs $18,000 to prepare her web-page design business for opening. Her bank will loan her the money at a banker's discount rate of 9.2% for 195 days. Find the face value of the note so that Ms. Harms will have the required $18.000. Use banker's interest of 360 days
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Greg has been making regular monthly payments of $425 into an account for 15 years, and he now has $96,000. What is the annual interest rate of his account? N=180 I= ? PV=96,000 PMT= 425 FV= ? P/Y= 12 C/Y=12 Missing Variable Value __________________ Context Sentence:
Use spreadsheet functions to solve the following. (Do not use the TVM formulas by hand unless you want practice or to check your spreadsheet commands.) Natalie is making monthly contributions of $210 to her investment account which pays interest at the annual percentage rate (APR) of 5.2%, compounded monthly. Right after Natalie makes her 36th contribution, the investment APR changes to 5.8% and Natalie makes 46 more $210 contributions. What is Natalie's balance right after her last contribution? Final answer = $ (Round to the nearest cent/penny.) After Natalie makes those first 36th contribution, and you know the amount in the account at that point, what single spreadsheet formula would give the final result that you reported above? Formula: v Select an answer 9 ( -PV Tip: Num eed to be mathematically accurate and do NOT have to look exactly like -FV .03 and those will be marked 12 -PMT spreadshi k like. You CAN enter things like 12*55, or correct if they are mathematically accurate.…
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Herman is looking to invest $5,000 in an account that earns 3.7% annual interest compounded semi-annually. If Herman plans to regularly deposit semi-annual payments of $1,575 into the account, how much is the account worth after 30 years? N=60 I= 3.7 PV=5000 PMT= 1575 FV= ? P/Y=2 C/Y=2 Missing Variable Value __________________ Context Sentence:
A student purchases a computer by obtaining a simple interest loan. The computer costs $1500, and the interest rate on the loan is 12%. Calculate the amount of interest paid over the 2 years. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Alexa takes out a loan of 94,000 at an annual effective discount rate of 6%. The loan is to be repaid with annual payments of 10,000. The first payment is due 4 years after the loan is taken out. Calculate the amount of the drop payment. Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answwer.
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Ted has been making regular daily payments of $17 into an account earning an annual interest rate of 2.9% compounded daily for 14 years. How much money does she now have? N=5110 I=2.9 PV=? PMT=17 FV= ? P/Y=365 C/Y=365 Missing Variable Value __________________ Context Sentence:
You are interested in saving for a trip when you graduate in three years. You can save $75 each of the next 36 months and earn 2.75% interest on your money. How much money would you have in your savings account in 36 months for your trip? ( Please reference the loan infromation in the "Task 5 Data " cells as the argument for your functions
Camila Martinez has several credit cards, on which she is carrying a total current balance of $6,500. She is considering transferring this balance to a new card issued by a local bank. The bank advertises that, for a 4 percent fee, she can transfer her balance to a card that charges a 0 percent interest rate on transferred balances for the first 6 months. Calculate the fee that Camila would pay to transfer the balance. $ Describe the benefits and drawbacks of balance transfer cards.
Read and analyze the situation below then answers the question given. Your mom asked your opinion if she will be joining the cooperative in her office. She wants to know the amount of money she will be receiving after 6 months and wanted to buy something in December. The cooperative wants her to contribute P1,000 per month beginning in June 2020 which will earn 3% compounded monthly. How much will be the future value of your mom's contribution at the end of December 2020? Tasks: You need to prepare a report showing a cash flow diagram on the total amount of money your mother will earn at the end of December. At the end of your report, write a conclusion stating your opinion to help your mom to decide.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS