show calculation step by step and do it on excel

Your friends were excited to hear you have chosen accounting for a career. They have several practical questions regarding money and interest (time value of money). Please assist your friends by answering their respective questions. For each question: Use two of the tools listed below, solve (answer the question). Include documentation, "step-by-step" detail showing your friend(s) how exactly you solved the question (see note below). Use two of the following three tools to solve each question. - EXCEL - Business calculator - Text tables Note: Include all the detail steps for each of the two tools you choose. The reader should be able to use your written steps to duplicate your calculation. For example, if using EXCEL show all formulas (copy so reader could duplicate your work). If using a business calculator, in detail in proper order show numbers and buttons you input to obtain your answer. Problems start with "Friend \#1" at the top of page 2. Friend \#1 - Car Loan - What will be my monthly payment if I purchase a used car for $28,500 ? The dealer has offered to finance the purchase (car loan) over four years at 5%. No down payment is required. Tool 1 Idently tool and show all the necessary stopssisuals so your "trend could dupicate your work. Tool2 Identify tool and show all the necessary stepsivisuas so your "trend could duplicute your work: Friend #2 - Credit Card Debt - How long will it take me to pay off my credit card balance of $13,750 ? The credit card company is charging 10% interest. I can afford to pay $250/ month but would prefer to pay $150 /month because I want to continue my cable service. Please show me the answer to both scenarios. Tool 1 Identify tool and show all the necessary steps/visuals so your "friend" could duplicate your work. Friend #3 - Home Mortgage Payment - I found my dream house in St. Paul, but I am not sure I can afford it? I have the $18,750 for the down payment but it is the monthly payments that I am not sure about? What will my monthly payments be? Selling price: $375,000 Down payment: $18,750 Loan: 30-year $356,250 loan at 6% Tool 1 Identify tool and show all the necessary steps/visuals so your "friend" could duplicate your work: Tool 2 Identify tool and show all the necessary steps/visuals so your "friend" could duplicate your work