Question: Please HELP ASAP! Need functions! In all problems, remember to use functions in Excel, and cell references when answering the questions. Problem 1: (10 points)

 Please HELP ASAP! Need functions! In all problems, remember to use

functions in Excel, and cell references when answering the questions. Problem 1:

Please HELP ASAP! Need functions!

In all problems, remember to use functions in Excel, and cell references when answering the questions. Problem 1: (10 points) Mr. Bill Buffett has lately started selling used cars. He has asked you to make a simple application for him to keep track of the monthly payments that he should receive from every customer. Use Excel functions to provide some analysis for Mr. Buffett. His current customers, their credit score, and vehicle prices are provided in the table in the worksheet "Problem 1." Add additional columns that provide the necessary numbers. For purchasing a used car, the customer's credit score will determine the available term of the loan, interest rate, and percent of the purchase price required as a down payment. For each customer, find the appropriate down payment, amount financed, loan term (months), and interest rate. Financing information is contained in the worksheet "Financing Table". Do not copy and paste the table to the "Problem1" worksheet. You need to refer to the cells of this table. Finally, calculate the Monthly payment for each loan. Problem 2: (10 points) You are a financial planning advisor who is trying to answer the questions of two customers: (3 points) Christine wants to know what the future value of her investments will be if: Her current investment 10000 Annual Interest Rate: 7% Number of Years to Invest: 25 Monthly payment into the fund: $800 (3 points) Doug wants to know if his goal is one million dollars, how much he should pay into his fund every quarter. Initial Value of Investment: $100,000 Expected Annual Interest Rate: 7.00\% Number of Years to Invest: 25

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!