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.

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.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

ChapterM: Time Value Of Money Module

Section: Chapter Questions

Problem 7MC

See similar textbooks

Similar questions

We can now use the following formula to find the present value of the account where the annuity payments are $400 each month. present value = table factor ✕ annuity payment The table factor was determined to be 21.67568. Before using the above formula, we must add 1 to the table factor since this is an annuity due. Thus, the table factor to use in the formula is 21.67568 + 1 = . Substitute the values into the formula, rounding the result to the nearest cent. present value = table factor ✕ annuity payment = ✕ 400 = $ Therefore, to receive annuity payments of $400 at the beginning of each month for 2 years, the amount that should be deposited now into an account earning 6% interest compounded monthly, to the nearest cent, is $ .
Using a spreadsheet generate your own set of Discount and AnnuityTables for, say, all discount rates between 1% and 20% (at 1 percentagepoint intervals) and for time periods 1 to 30 (at one time periodintervals), as well as time periods 50 and 100. You should generate thesetables by inserting the numbers for the time periods in the first columnof each row and the discount rates in the first row of each column, andthen inserting the appropriate formula into one cell of the table – year 1at 1% - and then copying it to all other cells in the matrix. (Hint: Do notforget to anchor the references to periods and discount rates using the“$” symbol.)Answer: Write the discount formula into spreadsheet as shown below and then copyacross 20 columns (headed 1% through 20%) and down 50 rows (headed 1 to 50).
What is the present value of $1,400 a year at a discount rate of 8 percent if the first payment is received 7 years from now and you receive a total of 25 annual payments? Could you please show how this can be solve by using Excel? Thank you.
Create the spreadsheet models shown in below images and answer the following questions. a. What is the effect of a change in the interest rate from 8% to 10% in the spreadsheet model shown in Figure A? b. For the original model in Figure A, what interest rate is required to decrease the monthly payments by 20%? What change in the loan amount would have the same effect? c. In the spreadsheet shown in Figure B, what is the effect of a prepayment of $200 per month? What prepayment would be necessary to pay off the loan in 25 years instead of 30 years?
Ramon Hernandez saw the following advertisement for a used Volkswagen Bug and decided to work out the numbers to be sure the ad had no errors. Cash price $7,940, Down payment $0, Annual percentage rate 16.03%, Deferred price $11,586.00 or 60 payments at $193.10 per month. What is the amount financed? What is he finance charge? What is the APR? What is the monthly payment by formula? Calculate the monthly payment by table lookup at 16.00%
What is the PV of an annuity due with 5 payments of $2,500 at an interest rate of 5.5%? Hint: when you see the word “due”, it means that the first payment happens right away (rather than at the end of the period) so you must adjust the formula, in Excel make type=1: =PV(Rate, nper, pmt, fv, type=1)
Please show how to solve this in Excel using Excel formulas and please show the spreadsheet so I can understand better. Suppose Tommy borrows $500,000 at 4% for 15 years and monthly payments. The annual percentage rate (APR) on the loan is 4.5%. What amount of discount points was charged if there was $4,500 origination cost?
Find the present value of an annuity immediate that has an initial payment of 450 with payments increasing by 75 for each subsequent period. The annuity provides 30 monthly payments and the interest rate is a nominal 8% compounded monthly. please do not use excel or a financial calculator to answer please answer using formulas and show all work etc
Using the information provided please show all work and formulas in excel ! Suppose that you have two loan choices with monthly payments (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans?
What’s the equivalent interest rate to the terms 3/20, n/60? In other words, what is the effective annual rate that is "given" to a customer for this cash discount? (Use 365 days.) HINT: Use the I = P x R x T formula where R = I/PT and choose some value for the gross amount of the invoice (i.e $1,000). Label (%) and round to the nearest whole percent.
Which one of the following bank accounts will you choose for a savings account? Bank A: An account that pays 8% nominal interest (APR) with daily (365-day)compounding. Bank B: An account that pays 8% nominal interest (APR) with annual compounding. Bank C: An account that pays 7% nominal interest (APR) with daily (365-day)compounding. Bank D: An account that pays 7% nominal interest (APR) with monthly compounding. Please explain your choice. show in excel for all choice to see calculations What is the effective annual return (EFF) of the account that you picked?
Please show me how to solve this in excel using an excel spreadsheet and please show the excel formulas! Thank You! A house price of $100,000 can be financed with two loans below with monthly payments. The total origination cost associated with these two loans in the table attached is $3000. Alternatively, the borrower can borrow one loan in the amount of $90,000 with monthly payments and origination cost of $2,000. What should the interest rate be on the loan of $90,000 so that the borrower will be indifferent between these two choices?