You have just read an advertisement stating, “Pay us $100 per year for 10 years, and we will pay you $100 per year thereafter forever.” If this is a fair deal, what is the rate of interest? Solve this problem in Excel, and print out a ONE PAGE view of your excel code. Make sure that the code that you used is visible. Do not exceed one page!
the rate of interest = 0.07177 = 7.18%

Please do rate me and mention doubts, if any, in the comments
section.
You have just read an advertisement stating, “Pay us $100 per year for 10 years, and...
5. (4 marks) You have just read an ad which says: "Deposit $550,000 with us today and we will pay you $50,000 a year from now and SX per year from year I to year 25. If this is a fair deal, and the interest rate is 4%, how much is ? Use 3 decimal points in your calculations.
13. A local bank is running the following advertisement in the newspaper: "For just $3,000 we will pay you $180 forever!" The fine print in the ad says that for a $3,000 deposit, the bank will pay $180 every year in perpetuity, starting one year after the deposit is made. What interest rate is the bank advertising (what is the rate of return of this investment)?
A local bank advertises the following deal: Pay us $100 at the end of each year for 10 years and then we will pay you (or your beneficiaries) $100 at the end of each year forever. a. Calculate the present value of your payments to the bank if the interest rate is 6.75%. (Do not round Intermediate calculations. Round your answer to 2 decimal places.) Present value b. What is the present value of a $100 perpetuity deferred for 10...
You have just landed your dream summer internship, and your boss asks you to analyze a project that has an investment cost of 3,500,000, to be paid today (t = 0), and will generate a cash-flow of 350,000 in the first year (t = 1). The cash-flow will then grow at 12% per year for the next eight years (the last time the cash-flow grows at 12% is from t = 8 to t = 9). Afterwards, as competition increases,...
If you pay $800 for the right to receive $100 per year for 5 years with $1,000 lump sum in year 5, what rate did you earn?
Assume that two athletes sign 10-year contracts that pay out a total of $100 million over the life of the contracts. One contract will pay the $100 million in equal installments over the 10 years. The other contract will pay the $100 million in installments, but the installments increase 5% per year. Which athlete received the better deal? You must show your work and explain your position in detail.
Compare alternatives A and B with the present worth method if the MARR is 10% per year. Which one would you recommend? Assume repeatability and a study period of 20 years $15,000 $45,000 Capital Investment Operating Costs $4,000 at end of year 1 and increasing by $400 per year thereafter $4,000 every 5 years 20 years $8,000 at end of year 1 and increasing by $800 per year thereafter None Overhaul Costs Life 10 years Salvage Value $8,000 if just...
Compare alternatives A and B with the present worth method if the MARR is 11% per year. Which one would you recommend? Assume repeatability and a study period of 12 years. $25,000 $10,000 at end of year 1 and increasing by $1,000 per year thereafter None Capital Investment Operating Costs $55,000 $5,000 at end of year 1 and increasing by $500 per year thereafter $5,000 every 3 years 12 years $10,000 if just overhauled Overhaul Costs Life 6 years negligible...
A company is offering bonds, which pay $100 per year indefinitely. If you require a 10 percent return on these bonds that is, the discount rate is 10 percent what is the value of each bond? Please show work, or what to type into financial calculator.
Your credit card charges an interest rate of 2% per month. You have a current balance of $1,000, and want to pay it off. Suppose you can afford to pay $100 per month. What will your balance be at the end of one year?