Answered step by step
Verified Expert Solution
Link Copied!

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. image text in transcribed

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 value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Auditing Security And Internal Control Manual

Authors: Javier F. Kuong

1st Edition

0131629670, 978-0131629677

More Books

Students also viewed these Accounting questions

Question

8. I dont get upset too easily.

Answered: 1 week ago