Fundamentals Of Financial Accounting
6th Edition
ISBN: 9781259864230
Author: PHILLIPS, Fred, Libby, Robert, Patricia A.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter C, Problem 5ME
To determine
To compute: the present value of $500,000 to be paid in 10 years with an interest rate of 8% with the help of excel.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
An annuity pays $200 at the end of each period for 10 periods. Set up the CFs in an Excel spreadsheet. The current value of this stream of CFs is $1,544. What is the implied discount rate? Solve the problem using the following approaches: a. Use trial and error or Goal Seek in Excel (tab Data/What-if-Analysis). b. Use the excel built-in function RATE.
uestion 1: Solve the following TVM problems using Excel formulas. You MUST use Excel formulas (FV or PV) to receive credit.
ou can assume that all payments are made at the beginning of the period and use "1" for the "type" argument in the formula.
A. Suppose you invest
11,400 today. What is the future value of the investment in
29 years, if interest at
7% is compounded annually?
B. Suppose you invest
$ 11,400 today. What is the future value of the investment in
29 years, if interest at
7% is compounded quarterly?
C. Suppose you invest
$
570 monthly. What is the future value of the investment in
29
29
years, if interest at
+
5% is compounded monthly?
5
6
7
8
19
20
21
22
23
24
25
26
27
28
29
Question 1
Question 2
+
Ready Accessibility: Investigate
MAR
17
A
国
W
X
ces
You have a choice of four increasing annuities as shown in the table below. Which annuity will reach a future value of $100,000 the earliest?
Annuity B
Annuity C
$1100
Annuity D
$800
$57
8%
3%
52
1
Payment
Annual Rate
Interest Periods
Per Year
Annuity A
$300
5%
12
(Use the interactive figure to find your answer.)
Click here to launch the interactive figure.
Choose the correct answer below.
OA. Annuity D
OB. Annuity A
OC. Annuity B
OD. Annuity C
9%
4
چلے
i, 14e
gin MLM
Incorrec
Chapter C Solutions
Fundamentals Of Financial Accounting
Ch. C - Prob. 1QCh. C - Prob. 2QCh. C - Which of the following is most likely to be an...Ch. C - Prob. 4QCh. C - Prob. 5QCh. C - Prob. 6QCh. C - Prob. 7QCh. C - You are saving up for a Mercedes-Benz SLR McLaren,...Ch. C - Prob. 2MCCh. C - Prob. 3MC
Ch. C - Prob. 4MCCh. C - Prob. 5MCCh. C - Assume you bought a car using a loan that requires...Ch. C - Assume you bought a car using a loan that requires...Ch. C - Which of the following statements is true? a. When...Ch. C - Prob. 9MCCh. C - Prob. 10MCCh. C - Prob. 1MECh. C - Prob. 2MECh. C - Prob. 3MECh. C - Prob. 4MECh. C - Prob. 5MECh. C - Prob. 6MECh. C - Prob. 7MECh. C - Prob. 8MECh. C - Prob. 9MECh. C - Prob. 10MECh. C - Prob. 11MECh. C - Prob. 12MECh. C - Prob. 1ECh. C - Prob. 2ECh. C - Prob. 3ECh. C - Prob. 4ECh. C - Prob. 5ECh. C - Computing Bond Issue Proceeds and Issue Price Your...Ch. C - Computing Missing Present or Future Values...Ch. C - Prob. 1CPCh. C - Prob. 2CPCh. C - Prob. 3CPCh. C - Prob. 4CPCh. C - Prob. 1PACh. C - Recording Equipment Purchase with Two-Year Note...Ch. C - Prob. 3PACh. C - Prob. 4PACh. C - Prob. 1PBCh. C - Recording Equipment Purchase with Two-Year Note...Ch. C - Prob. 3PBCh. C - Prob. 4PB
Knowledge Booster
Similar questions
- Questions: 1. Using simple interest computations, find the future value of $3,620 at 2 38%/2 38% 2. Now, using compound interest computations, find the future value of $3,620 at 2 38%/2 38% Time Value of Money Solver). Show what you put into the calculator for your work. 3. Now, using compound interest computations, find the future value of $3,620 at 2 38%/2 38% Time Value of Money Solver). Show what you put into the calculator for your work. 4. Explain why the future values are different in questions 1-3. Explain who would benefit from more frequent compounding. Who would be at a disadvantage from more frequent compounding.arrow_forwardEQuestion Help Use graphical approximation techniques or an equation solver to approximate the desired interest rate. A person makes annual payments of $1000 into an ordinary annuity. At the end of 5 years, the amount in the annuity is $5898.27. What annual nominal compounding rate has this annuity eamed? Type the interest rate: % (Round to 2 decimal places.) Enter your answer in the answer box and then click Check Answer. All parts showing Clear All Check Answer MacBook Air esc 80 888 DII F4 %23 $ & 2 3 4 6 8 9 Q E R Y A D G H K V B N Marrow_forwardUse financial calculator app to compute the present value of 10 equal payments of $15,400, with an interest rate of 11 percent. (Round "Present Value" to nearest whole dollar amount.) Calculator Function: Annuity payments: n = i = Present Value:arrow_forward
- Use financial calculator app to compute the present value of 10 equal payments of $16,000, with an interest rate of 8 percent. (Round "Present Value" to nearest whole dollar amount.) Calculator Function: Annuity payments: Present Value: no IN %arrow_forwardQ)You are given the future value of an annuity, A, the monthly payment, R, and the annual interest rate, r. Find the number of monthly payments, n. Round your answer to the nearest whole number if necessary.A = $4000; R = $70; r = 7% Solve it correctly not use excelarrow_forward2. If you receive $249 each quarter for 4 quarters and the discount rate is 0.08, what is the present value? (show the process and can use financial calculator)arrow_forward
- Question Content Area Use the present value and future value tables to answer the following questions. A. If you would like to accumulate $2,500 over the next 3 years when the interest rate is 15%, how much do you need to deposit in the account? $fill in the blank 1 B. If you place $6,300 in a savings account, how much will you have at the end of 8 years with a 12% interest rate? $fill in the blank 2 C. You invest $9,000 per year for 9 years at 12% interest, how much will you have at the end of 9 years? $fill in the blank 3 D. You win the lottery and can either receive $740,000 as a lump sum or $60,000 per year for 19 years. Assuming you can earn 8% interest, which do you recommend and why? Please round off answersarrow_forwardAnnuity Formulae Problem. only need help with d,e,f please. please type and explain You may want to use a spreadsheet to actually find the solutions to some of these problems. But make sure to write out the equations you need to solve in your answers. a. What is the present value of 15 annual payments of $100, with the first payment one year from now, if the discount rate is 0.05? b. What is the present value of 15 annual payments of $100, with the first payment right now, if the discount rate is 0.05? c. What is the present value of 15 annual payments of $100, with the first payment five years from now, if the discount rate is 0.05? d. At what discount rate would the present value of 15 annual payments of $100, with the first payment right now, be 0? e. How many annual payments of $100, with the first payment right now, would it take to be worth more than $1,000, if the discount rate is 0.05? f. What is the value of 15 annual payments which begin at $100 one year from now and increase…arrow_forwardCalculate the present value of the following annuities, assuming each annuity payment is made at the end of each compounding period. (FV of $1. PV of $1. FVA of $1, and PVA of $1) (Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places.) 1. 2. 3. Annuity Payment $ 5,600 10,600 4,600 Annual Rate Interest Compounded Semiannually 9.0% 10.0% Quarterly 11.0% Annually Period Invested 3 years 2 years 5 years Present Value of Annuityarrow_forward
- Problem 1: Read each problem carefully and answer each question to solve the problem. Find the period of deferral in each of the following deferral annuity problems (one way to find the period of deferral is to count the numnber of artificial payment (k). Make a diagram 1. Payment of P 3,000.00 every 3 months for 8 years that will start 6 years Time Diagram Answerarrow_forwardB. Problem Solving, Show your solution : simple interest 2. In what time will Php. 875.00 double itself at the rate of 7% simple interest?arrow_forwardCalculate the present value of the following annulties, assuming each annuity payment is made at the end of each compounding period. (FV of $1, PV of $1, FVA of $1, and PVA of S1) (Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places.) \table[[, \table[[Annuity], [Payment]], \table [[ Annual], [Rate]], \table[[Interest], [Compounded]], \table [[Period], [Invested]], \table [[Present Value of], [ Annuity]]], [1., $5,000, 7.0%, Semiannually,3 years,], [2., 10, 000, 8.0%, Quarterly,2 years, ], [3., 4,000, 10.0 %, Annually,5 years,]]arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education