Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please provide code used in each cell and screenshots. Suppose you wanted to buy an electrical generator on credit. The generator's cost is $100,000 and
please provide code used in each cell and screenshots.
Suppose you wanted to buy an electrical generator on credit. The generator's cost is $100,000 and you will be able to make a $10,000 down-payment. Assuming an annual interest rate of 7%, and a monthly payment of $1,200, use the following steps to generate a payment tracking tool, complete with a graphical output of payments. Step 1: Start by entering the given values, and creating columns in Excel to track the months and principle. The principle is how much is actually still owed towards the initial purchase. Start with month O, where the principle will be: Equip Cost Down Payment (1) In all following months (i=month number) the principle will be: Principlei+1 = Principle; + Interest Paymenti (2) You may need to move onto other steps first and come back to this. Step 2: In the next column, calculate your interest using the equation: Annual InterestRate Interest = Principle; * (3) 12 Step 3: In the next column, place your monthly payment (given above). Step 4: In the final column calculate the total money spent up to month i. Total Spent = Down Payment + - MonthlyPayment (4) Step 5: Use the scatter plot to graph Principle and Total Money spent as a function of months. On the same scatter plot, graph the monthly interest payment as a function of months. You will note that this appears not to change very much, but this is only because it changes little relative to other variables. To view its change, plot it on a differently scaled vertical axis by right clicking on one of the scatter plot points then selecting "format data series > series options > secondary axis. Format the graph appropriately to include a title and labels for all axes. Step 6: Continue the calculations until the principle reaches a value series options > secondary axis. Format the graph appropriately to include a title and labels for all axes. Step 6: Continue the calculations until the principle reaches a valueStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started