Question

How do I set this up in a table in excel?
3-51 Mona Persian is considering a new investment fund with a semiannual interest rate of 2.5%. Any money she invests would h
0 0
Add a comment Improve this question Transcribed image text
Answer #1

B B8 fx =FV(B7, B4, 0, -B2) А 1 Semiannual interest rate 2.50% 2 Amount invested $10,000.00 3 Compounding period per ye 4 Per

Add a comment
Know the answer?
Add Answer to:
How do I set this up in a table in excel? 3-51 Mona Persian is considering...
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
  • Jennifer Creek is saving up for a new car. She wants to finance no more than...

    Jennifer Creek is saving up for a new car. She wants to finance no more than $9,000 of the $21,000 estimated price in two years. She deposits $3,900 into a savings account now and will make monthly deposits for the next two years. Contributed by Gillian Nicholls, Southeast Missouri State University If the savings account pays a nominal interest rate of 8.5% per year with monthly compounding, how much must she deposit each month? $ Enter a number

  • 4-1 Rose recently graduated in engineering. Her 5 employer will give her a raise of $6500...

    4-1 Rose recently graduated in engineering. Her 5 employer will give her a raise of $6500 per year if she passes the FE exam (Fundamentals of Engineering) (a) Over a career of 45 years, what is the present worth of the raise if the interest rate is 4%? (b) What is the future worth at Year 45? (c) Incentive pay systems can create ethical dilem- mas in the workplace. Describe one each from the perspective of the employer and the...

  • 4-6 A man buys a ear for $18,000 with no money down. He pays for the...

    4-6 A man buys a ear for $18,000 with no money down. He pays for the car in 30 equal monthly pay- ments with interest at 12% per annum, compounded monthly. What is his monthly loan payment? 4-1 Rose recently graduated in engineering. Her employer will give her a raise of $6500 per year if she passes the FE exam (Fundamentals of Engineering). (a) Over a career of 45 years, what is the present worth of the raise ifthe interest...

  • 4-30 A man wants to help provide a college education for A his young daughter. He...

    4-30 A man wants to help provide a college education for A his young daughter. He can afford to invest $600/yr for the next 4 years, beginning on the girl's 4th birthday. He wishes to give his daughter $4000 on her 18th, 1gth, 20th, and 21st birthdays, for a total of $16,000. Assuming 5% interest, what uniform annual investment will he have to make on the girl's 8th through 17th birthdays? Tameshia deposits $5500 in her retirement account every year....

  • answer scenario 3 pls & explain how you got your answer/ show your work 1x) P12-55A...

    answer scenario 3 pls & explain how you got your answer/ show your work 1x) P12-55A (similar to) Question Help Solve various time value of money scenarios. (Click the icon to view the scenarios.) (Click the icon to view the present value of $1 table.) (Click the icon to view the present value of annuity of $1 table.) (Click the icon to view the future value of $1 table.) (Click the icon to view the future value of annuity of...

  • Hi, i just need the highlighted ones. Thank you! CHAPTER 1 Understanding Personal Finance 33 LET'S...

    Hi, i just need the highlighted ones. Thank you! CHAPTER 1 Understanding Personal Finance 33 LET'S TALK ABOUT IT 1. Economic Growth. What tpes of federal government Federal Reserve. Describe some economic circumstances that might persuade the Federal Reserve to lower short-term inter- ctfoets to help stimulate economic growth affect 2 The Business Cycle. Where is the United States in the economic cycle now, and where does it seem to be heading? List some indicators that suggest in which direction...

  • P12-55A (similar to) :3 Question Help Solve various time value of money scenarios. i (Click the...

    P12-55A (similar to) :3 Question Help Solve various time value of money scenarios. i (Click the icon to view the scenarios.) (Click the icon to view the present value of $1 table.) 5 (Click the icon to view the present value of annuity of $1 table.) (Click the icon to view the future value of $1 table.) 5 (Click the icon to view the future value of annuity of $1 table.) Scenario 1. Daniel just hit the jackpot in Las...

  • 0. Read examples 6 and 7 in the text 1. Write an instruction describing amortization tables in your words. Tell what information in the columns, how the information in the three main column is calcul...

    0. Read examples 6 and 7 in the text 1. Write an instruction describing amortization tables in your words. Tell what information in the columns, how the information in the three main column is calculated, and why it is useful, Do not use specific numbers, mathematical symbols, or excel functions, or cell references, Be sure to explain the calculations for the three columns. 2. Find the median home price for a city where you would like to live. Tell how...

  • This year Evan graduated from college and took a job as a deliveryman in the city....

    This year Evan graduated from college and took a job as a deliveryman in the city. Evan was paid a salary of $68,500 and he received $700 in hourly pay for part-time work over the weekends. Evan summarized his expenses below: Cost of moving his possessions to the city (125 miles away) Interest paid on accumulated student loans Cost of purchasing a delivery uniform Contribution to State University deliveryman program $1,200 2,840 1,440 1,320 Calculate Evan's AGI and taxable income...

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