Accounting Help for College and University Students

Understanding Excel formulas for financial analysis.

How do I use the Excel financial formulas to calculate present value, future value and discount rates?

Calculating the return on an investment for 1949 Vincent Black Shadow motorcycle

A 1949 Vincent Black Shadow Series V motorcycle sold for about $45,000 in 1996. If you were fortunate enough to have purchased one new for $630 in 1949, what return did you earn on your investment? If the value of a $20,000 1998 Bimota Supermono appreciates at the same rate, what will it be worth in another 47 years?

Determining the future value (FV) of a savings bond using Excel.

How do I set this problem up in a spreadsheet? You have just made your first $20,000 contribution to your individual retirement account. Assuming you earn an 11% rate of return and make no additional contributions, what will your account be worth when you retire in 45 years? What if you wait 10 years before contributing?

Calculating which investment option has the higher present value.

Investment X offers to pay you $2,000 per year for 10 years, whereas Investment Y offers to pay you $4,000 per year for 4 years. Which of these cash flow streams has the higher present value if the discount rate is 5%? If the discount rate is 15%?

Determine the value of an annuity paying $5000 per year for 15 years at 10%.

An investment offers $5000 per year for 15 years, with the first payment occurring 1 year from now. If the required return is 10%, what is the value of the investment?

Blue Grass Life: Determining the perpetuity values of a life insurance policy

Blue Grass Life insurance is trying to sell you an investment policy that will pay you and your heirs $10,000 per year forever. If the required return on this investment is 12%, how much will you pay for the policy?

Calculate the present value of an investment that is compounded daily.

An investment will pay you $45,000 in 6 years. If the appropriate discount rate is 8% compounded daily, what is the present value? Solve using a spreadsheet.

A discounted cash flow analysis: what is the present value of the cash flows?

If the appropriate discount rate for the following cash flows is 12.25 percent per year, what is the present value of the cash flows? Year 1 Cash flow is $1500. Year 2 cash flow is $3200. Year 3 cash flow is $7200. Year 4 cash flow is $9600.

Working with interest in an amortization schedule with equal payments. Attachments in Excel.

Prepare an amortization schedule for a 3-year loan of $40,000. The interest rate is 11 percent per year and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?

Question on PRICE and YIELD function in spreadsheet

Please see attached examples from my textbook. I don't have the PRICE and YIELD functions on my spreadsheet, so how would I solve similar problems to these? Thanks.