ZuoTi.Pro
Question

7. Consider Bay City Savings Bank, which pays 10.0 percent interest compounded continuously. a. What is the effective annual rate under these terms? b. What is the future value of a $10,000 lump sum after 5 years? c. What is the future value of a 5-year ordinary annuity with payments of $2,000 each?INPUT DATA: Lump Sum Analysis: Beginning amount Ending amount Interest rate Number of years # Periods per year $10,000.00 $20,000.00 10 . 00%must show how to do using excel functions not using an equation/hardcoding. Thanks if done correctly will upvote

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

File Home Page Layout FormulasData Review View dd-Ins Define Name PUse in Formula EP Create from Selection Defined Names Trace Precedents Show Formulas Trace Dependents Error Checking Remove Arrows Calculate Now Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function Watch Calculation Calculate Sheet wndow Name Used | Evaluate Formula Time Reference ▼ & Tng Functions ▼ Manager options . Function Library Formula Auditing Calculation EN452 EK EL EM EN EO EP EQ ER ES ET 438 439 440 a 441 442 443 b RATE 1096 COMPOUNDED CONTINUOUSLY EAR 10.52% EXP(EM440) -1 PV YEARS FUTURE VALUE 10000 445 446 447 C 448 449 450 451 452 453 454 455 456 il 1 r n CALCULATOR ( LOAN OPTIONS | pv, fy, annuity i CAP STRU VALUE $16,487.21 FV(EM441,EM444,-EM443) PMT YEARS FUTURE VALUE 2000 $12,336.51 FV(EM441,EM448,-EM447 BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2 ShelI rences: x261 福 130% 0:04 21-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
must show how to do using excel functions not using an equation/hardcoding. Thanks if done correctly...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Please avoid using excel to solve the problem. Thanks! 7) If the corporate tax rate is...

    Please avoid using excel to solve the problem. Thanks! 7) If the corporate tax rate is 40% and the individual tax rate is 20% (and these are the only taxes), if a corporation has $50,000 of operating income, what is the after tax income for its owners? The tax rate is 15% between $0-$50,000 and 25% between $50,001-S 100,000. If you earn $60,000, then what is your average and marginal tax rates? A bank has quoted to you a monthly...

  • Need assitance with E, F, G. Please refrain from using Excel! Thanks! 7) a) If the...

    Need assitance with E, F, G. Please refrain from using Excel! Thanks! 7) a) If the corporate tax rate is 40% and the individual tax rate is 20% (and these are the only taxes), if a corporation has $50,000 of operating income, what is the after tax income for its owners? b) The tax rate is 15% between $0-$50,000 and 25% between $50,001-$100,000. If you earn $60,000, then what is your average and marginal tax rates? A bank has quoted...

  • Using the letters shown by each problem type, indicate what type of problem the question describes....

    Using the letters shown by each problem type, indicate what type of problem the question describes. A. Capital Gains/Loss between two consecutive periods B. Current Yield between Two Consecutive Periods C. Finding period 1's price of a stock with super-normal growth D. Finding today's price of a stock with super-normal growth E. Lump sum funds a delayed level annuity F. Lump Sum funds Future Lump Sum G. Lump Sum Funds Ordinary Level Annuity H. Ordinary Level Annuity Funds a Future...

  • 5. An amount is desited for cight years at 96. If compounding occurs quarterly, then the table value is found at A)...

    5. An amount is desited for cight years at 96. If compounding occurs quarterly, then the table value is found at A) 896 for eight periods. B) 296 for eight periods. C) 96 for 32 periods D) 2% for 32 periods. 6. Betty wants to know how much she should begin saving each month to fund her retirement. What kind of problem is this? A) Present value of one. B) Future value of an ordinary annuity. C) Present value of...

  • Time Value of Money In solving these problems please use Excel formulas of the time value of money valuation including : Present Value / PV, Future Value / FV, interest Rate / Rate, Number of periods...

    Time Value of Money In solving these problems please use Excel formulas of the time value of money valuation including : Present Value / PV, Future Value / FV, interest Rate / Rate, Number of periods / NPER First National Bank TIME VALUE OF MONEY ANALYSIS You have applied for a job with a local bank. As part of its evaluation process, you must take an examination on time value of money analysis covering the following questions: 1. Draw time...

  • Betty Bronson has just retired after 25 years with the electric company. Her total pension funds...

    Betty Bronson has just retired after 25 years with the electric company. Her total pension funds have an accumulated value of $340,000, and her life expectancy is 16 more years. Her pension fund manager assumes he can earn a 11 percent return on her assets. What will be her yearly annuity for the next 16 years ANNUAL INTEREST RATE # of times Interest is compounded during 1 year TERM # OF PERIODS INTEREST RATE PER PERIOD PRESENT VALUE (Lump Sum)...

  • Definition/Explanation Discounting/Compounding . What is an annuity? What is the difference between an ordinary annuity &...

    Definition/Explanation Discounting/Compounding . What is an annuity? What is the difference between an ordinary annuity & annuity due? .How does the FV and PV increase/decrease as the time and interest rates increase/decrease? TVM problems (lump sum problems only) that ask you to solve for the following: o Number of periods o Interest rate o Present Value o Future Value

  • Please show all work You expect to receive a lump sum amount of $20,000 fifty years...

    Please show all work You expect to receive a lump sum amount of $20,000 fifty years from now. But you want that money now.    So what is the present value of that sum if the current discount rate is 7.5%? Assume annual compounding. 2.   You have just purchased a $1,500 five year certificate of deposit (CD) from a savings bank which will pay 3.5%    interest compounded monthly. What will that CD be worth at maturity? 3.   Calculate the...

  • hello. i need some help in this. Name: Calculation of Present Value of a Lump Sum...

    hello. i need some help in this. Name: Calculation of Present Value of a Lump Sum You have been offered a security investment such as a bond that will pay you Php 10,000 at the end of 6 years in exchange for a fixed payment today, the appropriate annual interest rate on the investment is 12% compounded annually, what is the present value of the investment? Calculation of Future Value of a Lump Sum You plan to invest Php 10,000...

  • Use Table 12-1 to calculate the future value of the following annuity due. Round your answer...

    Use Table 12-1 to calculate the future value of the following annuity due. Round your answer to the nearest cent. Click here for Table 12-1 Annuity Payment Payment Frequency Time Period (years) Nominal Rate (%) Interest Compounded Future Value of the Annuity every month monthly $ Solve the following by using Table 12-1. Suntech Distributors, Inc., deposits $6,000 at the beginning of each 3-month period for 6 years in an account paying 6% interest compounded quarterly. Round your answers to...

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