Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show them in excel calculations! 14. What is the future value of weekly payments of $25 for six years at 10 percent? ($10,673.90) 15.

image text in transcribed

Please show them in excel calculations!

14. What is the future value of weekly payments of $25 for six years at 10 percent? ($10,673.90) 15. At the end of this month, Bryan will start saving $80 a month for retirement through his company's retirement plan. His employer will contribute an additional \$.25 for every $1.00 that Bryan saves. If he is employed by this firm for 25 more years and earns an average of 11 percent on his retirement savings, how much will Bryan have in his retirement account 25 years from now? (\$157,613.33) 16. Sky Investments offers an annuity due with semi-annual payments for 10 years at 7 percent interest. The annuity costs $90,000 today. What is the amount of each annuity payment? ($6,118.35) 17. Mr. Jones just won a lottery prize that will pay him $5,000 a year for thirty years. He will receive the first payment today. If Mr. Jones can earn 5.5 percent on his money, what are his winnings worth to him today? ($76,665.51) 18. You want to save $75 a month for the next 15 years and hope to earn an average rate of return of 14 percent. How much more will you have at the end of the 15 years if you invest your money at the beginning of each month rather than the end of each month? (\$530.06) 19. What is the effective annual rate of 10.5 percent compounded semi-annually? ( 10.78%) 20. What is the effective annual rate of 9 percent compounded quarterly? (9.31\%) 21. Fancy Interiors offers credit to customers at a rate of 1.65 percent per month. What is the effective annual rate of this credit offer? (21.70%) 22. What is the effective annual rate of 12.75 percent compounded daily? (13.60 percent) 23. Your grandparents loaned you money at 0.5 percent interest per month. The APR on this loan is percent and the EAR is percent. (6.00;6.17) 24. Three years ago, you took out a loan for $9,000. Over those three years, you paid equal monthly payments totaling $11,826. What was the APR on your loan? (18.69%)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions