Please use excel to do your analysis. Follow the steps and have a what if analysis...

Please use excel to do your analysis. Follow the steps and have a what if analysis data table for your car loan case. You are loaning 20,000 with 8.5 % interest for 60 months. In this scenario you need to pay $410 monthly. Use Excel’s PMT function to calculate monthly loan amount. What will your monthly payment be if you have different interest rates and terms (total term of months). Use Excel’s what if data table analysis to check various options with different interest rates and terms. (range your interest rates between 3% to 11% with 0.5 % increments, term as 24 months to 90 months increasing 6 months each time.) Also add data validation to loan amount. Prepare a list of various loan amounts (15,000 20,000 25,000) My Car Loan Loan Amount 20000 Term (months) 60 Interest Rate 8.5% Payment ($410.00)

Solutions

Expert Solution

For Data Validation

jeff jeffy answered 10 months ago

Next > < Previous

Related Solutions

PLEASE DO NO USE EXCEL, as we are not able to use excel on our test...

PLEASE DO NO USE EXCEL, as we are not able to use excel on our test XYZ company is considering a new machine that costs $300,000 and would reduce pre-tax manufacturing costs by $108,000 annually. XYZ would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $23,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The net operating working capital...

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company...

PLEASE DO NOT USE EXCEL, as we cannot use excel on our test. The Wagner Company currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6-years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $350 [($2,100/6) = $350 per year]. If the old machine is not replaced, it can...

Please Use Excel To Show All Work, I will like your asnwer if you do this...

Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area...

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area of sleep aids. Its major product is “Dozealot”. The Research-and-Development Division has defined two alternatives to improve the quality of the product. These alternatives are simple reformulations of the product to minimize the side effects and to improve the product efficacy. To conduct an analysis, management has decided to consider the possible demands for the drug under each alternative. The following payoff table shows...

What type of Analysis function do you use to perform your tracking and have so seem...

What type of Analysis function do you use to perform your tracking and have so seem an decrease or increase in costs over the years?

how do you find frequency and percent frequency of a data set on excel? steps please!...

how do you find frequency and percent frequency of a data set on excel? steps please! :)

Please if you could do each problem, and show steps for excel! Thank you! You will...

Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...

Please do not use Excel to answer this. I need the computations as we are not...

Please do not use Excel to answer this. I need the computations as we are not allowed to use excel. Sequential Method Jasmine Company manufactures both pesticide and liquid fertilizer, with each product manufactured in separate departments. Three support departments support the production departments: Power, General Factory, and Purchasing. Budgeted data on the five departments are as follows: Support Departments Producing Departments Power General Factory Purchasing Pesticide Liquid Fertilizer Overhead $80,000 $312,000 $165,000 $78,500 $107,400 Square feet 1,500...

Please explain your answers and use Excel to show the excel formula you used to get...

Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?

What is the use of regression analysis (Please support your answer with suitable example)?

Subjects