YOF EWS11 H1 – Loan Analysis 1.1
Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name. 
0 
2 
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places. Hint: Make the PV argument a negative value to make the APR a positive value. 
10 
3 
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
4 
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6. 
4 
5 
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency. 
10 
6 
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
7 
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6. 
4 
8 
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places. 
10 
9 
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
10 
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6. 
4 
11 
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places. 
4 
12 
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places. 
5 
13 
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places. 
5 
14 
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places. 
4 
15 
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places. 
10 
16 
Click Save, close Excel, and then submit the file as directed. 
0 

Total Points 
100 
YOF EWS11 H1 – Loan Analysis 1.1
Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name. 
0 
2 
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places. Hint: Make the PV argument a negative value to make the APR a positive value. 
10 
3 
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
4 
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6. 
4 
5 
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency. 
10 
6 
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
7 
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6. 
4 
8 
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places. 
10 
9 
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
10 
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6. 
4 
11 
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places. 
4 
12 
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places. 
5 
13 
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places. 
5 
14 
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places. 
4 
15 
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places. 
10 
16 
Click Save, close Excel, and then submit the file as directed. 
0 

Total Points 
100 
YOF EWS11 H1 – Loan Analysis 1.1
Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name. 
0 
2 
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places. Hint: Make the PV argument a negative value to make the APR a positive value. 
10 
3 
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
4 
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6. 
4 
5 
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency. 
10 
6 
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
7 
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6. 
4 
8 
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places. 
10 
9 
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
10 
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6. 
4 
11 
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places. 
4 
12 
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places. 
5 
13 
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places. 
5 
14 
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places. 
4 
15 
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places. 
10 
16 
Click Save, close Excel, and then submit the file as directed. 
0 

Total Points 
100 
YOF EWS11 H1 – Loan Analysis 1.1
YOF EWS11 H1 – Loan Analysis 1.1YOF EWS11 H1 – Loan Analysis 1.1YOF EWS11 H1 – Loan Analysis 1.1
Project Description:
Project Description: Project Description: Project Description:
Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.
Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.Janette Franklin, owner of Frank Solutions, LLC, is considering borrowing $30,000 to finance the renovation of her office building. She has been given three different loan options with various terms and interest rates. She knows that she can only afford to make payments of $530.00 a month and needs your help to determine which loan option is best.
Instructions:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name. 
0 
2 
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places. Hint: Make the PV argument a negative value to make the APR a positive value. 
10 
3 
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
4 
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6. 
4 
5 
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency. 
10 
6 
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
7 
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6. 
4 
8 
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places. 
10 
9 
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency. 
10 
10 
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6. 
4 
11 
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places. 
4 
12 
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places. 
5 
13 
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places. 
5 
14 
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places. 
4 
15 
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places. 
10 
16 
Click Save, close Excel, and then submit the file as directed. 
0 

Total Points 
100 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints Possible
1
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name.
0
2
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places.
Hint: Make the PV argument a negative value to make the APR a positive value.
10
3
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
4
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6.
4
5
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency.
10
6
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
7
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6.
4
8
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places.
10
9
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
10
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6.
4
11
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places.
4
12
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.
5
13
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places.
5
14
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places.
4
15
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places.
10
16
Click Save, close Excel, and then submit the file as directed.
0
Total Points
100
1
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name.
0
1
1
111
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name.
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name.
Start Excel. Open the file named e06ws11Loans.xlsx. Save the file with the name e06ws11Loans_LastFirst, replacing LastFirst with your name.
e06ws11Loans.xlsxe06ws11Loans_LastFirst,
0
0
0
2
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places.
Hint: Make the PV argument a negative value to make the APR a positive value.
10
2
2
222
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places.
Hint: Make the PV argument a negative value to make the APR a positive value.
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places.
On the LoanAnalysis worksheet in cell C4, calculate the annual percentage rate for Loan Option 1. Format the cell as Percentage with 2 decimal places.C4Percentage 2
Hint: Make the PV argument a negative value to make the APR a positive value.
Hint: Make the PV argument a negative value to make the APR a positive value.
10
10
10
3
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
3
3
333
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell C6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell C5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.C6C5 end_period Currency
10
10
10
4
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6.
4
4
4
444
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6.
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6.
In cell C7, calculate the total cost of the loan by adding the loan amount in cell C2 to the cumulative interest amount in cell C6.C7C2 C6
4
4
4
5
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency.
10
5
5
555
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency.
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency.
In cell F3, calculate the end of the period monthly payment for Loan Option 2. Be sure the result of the function is positive, and then format the cell as Currency.F3Currency
10
10
10
6
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
6
6
666
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell F6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell F5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.F6F5 end_period Currency
10
10
10
7
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6.
4
7
7
777
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6.
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6.
In cell F7, calculate the total cost of the loan by adding the loan amount in cell F2 to the cumulative interest amount in cell F6.F7F2 F6
4
4
4
8
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places.
10
8
8
888
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places.
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places.
In cell I5, calculate the total number of quarterly payments required to pay off Loan Option 3 if payments are made at the end of the period. Format the cell as Number with 0 decimal places.I5Number 0
10
10
10
9
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
10
9
9
999
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.
In cell I6, calculate the total cumulative interest that would be paid throughout the life of the loan if payments were made at the end of the periods. Reference cell I5 for the end_period argument. Be sure that the result of the function is positive, and then format the cell as Currency.I6I5 end_period Currency
10
10
10
10
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6.
4
10
10
101010
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6.
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6.
In cell I7, calculate the total cost of the loan by adding the loan amount in cell I2 to the cumulative interest amount in cell I6.I7I2 I6
4
4
4
11
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places.
4
11
11
111111
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places.
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places.
You will create an amortization schedule for Loan Option 3 in cells C12:F35. All payments are endoftheperiod payments. Be sure that all formulas and functions result in a positive value. To begin, in cell C12, enter a formula that refers to the Loan Amount for Loan Option 3. Format the cell as Currency with 2 decimal places. C12:F35
4
4
4
12
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.
5
12
12
121212
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.
In cell D12, enter a function to calculate the first principal payment. Format the cell as Currency with 2 decimal places.D12
5
5
5
13
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places.
5
13
13
131313
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places.
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places.
In cell E12, enter a function to calculate the first interest payment. Format the cell as Currency with 2 decimal places.E12
5
5
5
14
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places.
4
14
14
141414
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places.
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places.
In cell F12, enter a formula to calculate the first ending balance. Format the cell as Currency with 2 decimal places.F12
4
4
4
15
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places.
10
15
15
151515
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places.
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places.
In cell C13, enter a formula that refers to the ending balance in cell F12. Complete the amortization schedule as directed down to F35. Ensure that cells C13:F35 are formatted as Currency with 2 decimal places.C13F12F35C13:F35
10
10
10
16
Click Save, close Excel, and then submit the file as directed.
0
16
16
161616
Click Save, close Excel, and then submit the file as directed.
Click Save, close Excel, and then submit the file as directed.
Click Save, close Excel, and then submit the file as directed.
0
0
0
Total Points
100
Total Points
Total Points
Total PointsTotal PointsTotal Points
100
100
100100100