Check various option with different interest rates and terms

Assignment Help Financial Management

Reference no: EM131967820

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)

Reference no: EM131967820

Questions Cloud

The company need to meet its target fixed assets-sales ratio : how large of an increase in fixed assets will the company need to meet its target fixed assets/sales ratio?

What is the firms tax liability : The firm also had $8 million in depreciation expense, and sold land for $3.5 million that had been purchased for $2.5 million several years earlier.

Why is water important in biological systems : Define anabolism and catabolism, and discuss how they relate to homeostasis? Explain the chemistry of water. Why is water important in biological systems?

What do you notice about the length of the interval : In the discussion for week 4, you rolled a pair of dice 10 times and calculated the average sum of your rolls. Then you did the same thing with 20 rolls.

Check various option with different interest rates and terms : Use Excel’s what if data table analysis to check various options with different interest rates and terms.

Processes and supporting processes : Differentiate between value creation (core) processes and supporting processes. Provide an example of each process.

Develop screen designs for two must stories : prepare a briefing note for the Organisational change and Training Team on the anticipated business impact of the system

Compare the net amount of funds initially available-inflow : For a public issue, the interest rate will be 12 percent, and the underwriting spread will be 3 percent. There will be $150,000 in out-of-pocket costs.

Methods and sources an organization : What are the most useful methods and sources an organization can use during the hiring process? What method would be best to use during the selection process?

User Account

All Pages