Question: please help me figure out the formulas for the highlighted boxes that will appropriately change when summary loan data for year changes. thank you! A

please help me figure out the formulas for the highlighted boxes

please help me figure out the formulas for the highlighted boxes that will appropriately change when "summary loan data for year" changes. thank you!

A B C D E F G 1 Amortization Table - Breaking Down Your Payment - No video 2 3 This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references. 4 5 6 Initial Balance $ 10,000.00 7 Annual Interest Rate 10% 8 Years 10 9 Annual Payemnt 10 11 Summary loan data for year Insert a spinner to change the year. 1 Creating spinners is discussed in the first Excel exercise for chapter 6. 13 Balance at start of year 14 Balance at end of year 15 Interest paid during the year 16 Principle paid during the year A B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please help me make this excel spreadsheet. It is for CSIS 100 class and I have no access to excel. Thank you for your time! I can plug my numbers and what not in I just don't have enough time with...

Seminar in Finance: Can you please help me figure out how to do the Sensitivity and Scenario analysis? Greatly appreciated! sensitivity analysis: Scenario Analysis: Case - Canyon Buff's Chemical...

Please help me! I asked this question earlier and received help but I need the formulas within the excel sheet for ALL answers. The directions are very clear about this. So please help me by showing...

Please help me! If you read through the instructions carefully you will note that the main excel file shown will be copied & pasted twice more to fill the requirements. Meaning, all this is posted is...

I am unsure how to fill out the charts please help. The first 6 charts. Wherever there are green boxes is where numbers are inserted. The reat of the charts are there to help. Please let me know if...

I am struggling to do the proper computations for some simple accounting. After i get this down, i will produce a paper on the importance of each number i solved for. Can someone please help me...

Please help me figure out these ratios, I made mistake in the first Excel assignment, and cannot figure out the second one. I attached the my excel assignment along with the question pdf. For my...

this report is written about why Target Canada failed and what is the caused of failure Can you please read the report from the pictures and tell me what is the poor elements of this report? if we...

Please help me figure out this Nike Case Study. It is an investment analysis question. I attached the case study to this question. Thank you! An Investment Analysis Case Study: Nike This case is a...

PLEASE HELP ME FIGURE OUT THE WORKSHEET. It would be awesome if there was a filled out answer! Transaction Description of transaction June 1: Hudson Bloom invested $190,936.00 cash and computer...

A 2-mm-thick layer of water on an electrically heated plate is maintained at a temperature of Tw = 340 K, as dry air at T = 300 K flows over the surface of the water (case A). The arrangement is in...

In an Atkinson engine the following data are obtained: compression in 2 of 100kpa at 25 C until reaching 3 where the pressure is 5bar. The addition of heat at v = constant is carried out up to a...

If demand for financial advisor services increase white supply of financial advisors decrease

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...