Explain answers based on how you would put it on excel. Thanks

Assume that multiple cash flows are at the end of each relevant period unless told otherwise. That means that "Type" in the Excel formula should NOT be 1. A small number of problems do not have built-in Excel functions. In the Overview video, see the discussion concerning perpetuities and growing perpetuities. Some problems have multiple cash flows of the same amount. In Excel this is a PMT. When there are multiple cash flows of a different amount you will have to treat each cash flow separately. In such a case it is often useful to put the cash flows on a time line in order to help you get the time periods (NPER in Excel) correct. Remember that RATE and NPER must be consistent with the compounding periods, e.g., yearly, monthly, or daily. You decided to start saving up for your child's college tuition by putting $2000 per year into a bank savings account that pays 2% per year. How much will you have to pay tuition in 12 years? Your organization wishes to deposit $20,000 into the bank to replace some equipment in three years. You found a three-year bank certificate of deposit that pays 3.25% per year. How much money will you have in three years to buy the equipment? You have been offered an investment that pays $1500 per year for four years. If your required return is 8%, what is the most you would be willing to pay to get this investment? In other words, what is this investment worth today? The Elizabeth Organization has a $25,000 note receivable due in four years. How much is the note worth today if the relevant interest rate is 5%. You and your spouse conclude that you would like to have $1,000,000 saved up in 30 years when you expect to retire. If you can cam 9% per year in a retirement fund, how much do you need to save each year to meet your goal? Suppose that you want to provide your favorite charity with a continuous cash flow of $5000 per year to support their worthy efforts. At an interest rate of 4%, what amount today would generate a continual $5000 per year? Suppose that you deposited $6000 into an account paying 2.5% per year, compounded daily. How much money would be in the account in three years? Consider Mirage, Inc., a firm that specializes in difficult-to-see processes. Claudia has come to know this firm, and thinks it might be a good investment opportunity. She estimates a required rate of return of 15%. (a)If she expects the company to continue to pay the current $2 dividend indefinitely, what is the maximum she should be willing to pay for a share of Mirage stock? (b)Now suppose she expects the dividend to grow at a constant 4% rate. What is the maximum she should be willing to pay? Suppose that you are offered an investment that is expected to pay you $1000 in 1 year, $3000 in 2 years, $3000 in 3 years, and $5000 in 4 years. Your opportunity cost is 10%. What is the maximum you would be willing to pay for this investment