in an excel spread sheet please answer the following questions
ALL OF THE FOLLOWING ARE ON SEPERATE SHEETS IN THE ATTACHED EXCEL DOCUMENT
sheet 1:
You are going on a dream vacation with five of your closest friends for a week. Since you are taking a math course, your friends asked you to come up with a budget to see how much it will cost each of you. Please identify your location in the US and then determine the total costs – remember to be thorough so the group does not run out of money. Your expense list must include the following (this means that you cannot book an all-expenses paid trip)
sheet 2:
Suppose you all decide you want to finance the trip with a loan.Find two different available offers (the internet is a good source). Make sure the interest rate and loan length are both different in each option.Calculate the monthly payment amount, the total amount you will pay over the life of the loan and the total interest you will pay.NOTE: Do not provide personal information on the internet. You can find loan rates on major bank and credit union websites without providing personal information.
Loan payment formula:PMT = P*(r/n)/(1 – (1 + r/n)^(-n*t))
PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.
You must use Excel formulas including cell references to calculate the loan payment, total paid and interest paid.
Discuss which loan would be a better option and why: (14 points!)
Sheet 3:
Using the data set of 102 random heights provided use Excel formulas to find the following: