You have a chance to buy an annuity that pays $50,000 at the beginning of each year for 15 years. You could earn 10.0% on your money in other investments with equal risk. What is the most you should pay for the annuity?

You are planning to put $1,060 in the bank at the end of each year for the next three years in hopes that you will have enough money for a newest LCD model that is available. If you are investing at an annual interest rate of 12%, you'll have accumulated at the end of three years. How would you plug this into a BA II calculator?

Hi There! I solved the problem below, but can you answer the question and put everything on an excel spreadsheet and show the formulas please for the questions below. You are offered the opportunity to put some money away for retirement. You will receive 10 annual payments of $5,000 each beginning in 26 years. If you desire an annual interest rate of 12% compounded monthly, answer the following two questions:   How much would you be willing to invest today? How much would the money (that you will be willing to invest today) be worth at the end of your last payment (i.e., in year 35)?   Amount that you would be willing to invest today = PV = $5,000/(1.01)26*12 + $5,000/(1.101)27*12 + $5,000/(1.01)28*12 + $5,000/(1.01)29*12 + $5,000/(1.01)30*12 + $5,000/(1.01)31*12 + $5,000/(1.01)32*12 + $5,000/(1.01)33*12 + $5,000/(1.01)34*12 + $5,000/(1.01)35*12 = $1,388.638 Amount that would the money worth at the end of your last payment = FV = $1388.64 * (1+ 0.01)35*12 = $90691.52

With the given information please confirm if my calculations for how many years it will take to pay off this loan are correct.  I need to use excel formulas. Amoutn of loan: 50,000 annual payment 10,000 interest rate: 8% I used the NPER function on excell and my answer was 6.64 years, is this correct?

A real estate property is on the market.  You have estimated it will give you net cash flows of $5353 per month.  You hope to sell it in 7 years for $334380. Your required return is 9.24%, how much should you be willing to pay for the property today?  Answer:

You estimate that you can save $3,900 by selling your home yourself rather than using a real estate agent. What would be the future value of that amount if invested for seven years at 5 percent? Use Exhibit 1-A. (Round FV factor to 3 decimal places to 2 decimal places.). Better if you use your calculator. and final answer Future value

Your broker has offered you an investment opportunity at a cost of $ 500. The opportunity offers $100 in 1 year, $200 in 2 years, and $300 in 3 years. If you require a 10% return on investments of similar risk, should you take the opportunity?

Future Value of an Annuity Find the future value of the following annuities. The first payment in these annuities is made at the end of Year 1, so they are ordinary annuities. (Notes: If you are using a financial calculator, you can enter the known values and then press the appropriate key to find the unknown variable. Then, without clearing the TVM register, you can "override" the variable that changes by simply entering a new value for it and then pressing the key for the unknown variable to obtain the second answer. This procedure can be used in many situations, to see how changes in input variables affect the output variable. Also, note that you can leave values in the TVM register, switch to Begin Mode, press FV, and find the FV of the annuity due.) Do not round intermediate calculations. Round your answers to the nearest cent. $600 per year for 10 years at 14%. $   $300 per year for 5 years at 7%. $   $600 per year for 5 years at 0%. $   Now rework parts a, b, and c…

Please Use an excel spreadsheet and show all of the steps to solve the following Please: You buy a house of $450,000 today. You put a down payment of 20% and borrow a fixed-rate mortgage of $360,000 with interest rate of 4% and 15 years. After 3 years, your house is appreciated to the value of $550,000 and market interest rate goes up to 6.5%. How much money will you make in book after 3 years?

Provide step by step manula solution, formula, and diagram.  An investor have a projected surplus income of P1000 per year which he plans to place in a bank which offers an interest of 18% per annum for time deposit over 5 years. Compute how much shall the investor collect at the end of 13 years