Help doing this problem with steps please. There's little guidance and I'm unsure how to complete it. Below is all the information provided you me

Chapter 7: Excel Assignment Create an Excel spreadsheet which creates an amortization schedule for the issuance of a note receivable. Create an area in your schedule, for input of data including face amount of note, market rate, interest rate, and number of periods. After a user inputs those 4 amounts, the spreadsheet should produce an amortization schedule and the journal entries. (i.e. If the user changes the periods, the schedule should automatically adjust by adding and subtracting lines in the table.) Illustration Input Area Enter the following Information for the Note Receivable Face Amount Annual Market Interest Rate Annual Stated Rate Number of Periods Note: After a user of the worksheet enters the following values, the rest of the worksheet should populate automatically. In other words, all formulas in the worksheet should link to these values. Hints: 1. You will need to calculate the present value of the note using the PV function in Excel. 2. he amortization schedule should end when the periods end...and the periods change from problem to problem. Use the "IF" function in Excel. 3. If you don't want Excel to produce a value in a cell, type " in your equation 4. Use if you want an equation which "does not equal". 5. Use $ for absolute value (i.e. Sb$1). Chapter 7: Excel Assignment Create an Excel spreadsheet which creates an amortization schedule for the issuance of a note receivable. Create an area in your schedule, for input of data including face amount of note, market rate, interest rate, and number of periods. After a user inputs those 4 amounts, the spreadsheet should produce an amortization schedule and the journal entries. (i.e. If the user changes the periods, the schedule should automatically adjust by adding and subtracting lines in the table.) Illustration Input Area Enter the following Information for the Note Receivable Face Amount Annual Market Interest Rate Annual Stated Rate Number of Periods Note: After a user of the worksheet enters the following values, the rest of the worksheet should populate automatically. In other words, all formulas in the worksheet should link to these values. Hints: 1. You will need to calculate the present value of the note using the PV function in Excel. 2. he amortization schedule should end when the periods end...and the periods change from problem to problem. Use the "IF" function in Excel. 3. If you don't want Excel to produce a value in a cell, type " in your equation 4. Use if you want an equation which "does not equal". 5. Use $ for absolute value (i.e. Sb$1)