The Business Manager of a Commercial Laboratory needs to determine the present value of a $170,000 investment received at the end of year 7. What is the present value of the investment if the discount rate is 6%? Calculate in Excel

Jackson Clinic is starting an endowment fund to pay for the expenses of a allied health training program. The expenses are $2,500,000 per year, and the program needs to be endowed for 50 years. Assuming payments are made at the end of each year and the interest rate is 7% per year, what should be the initial size of the endowment? Calculate in excel.

An Allied Health Scholarship fund wants to insure that it can provide $50,000 annually in scholarships forever How much money would have to be reinvested each year at 8% interest to generate the funds for the scholarships?Calculate in Excel