Question: In cell B39, use the CUMPRINC function to calculate the end of period cumulative principal payment amounts for each period for loan option 4. Use

In cell B39, use the CUMPRINC function to calculate the end of period cumulative principal payment amounts for each period for loan option 4. Use cell references for all arguments and make sure the result is positive. Autofill the function down through B78.

In cell C39, use the CUMIPMT function to calculate the end of period cumulative interest payment amounts for each period for loan option 4. Use cell references for all arguments and make sure the result is positive. Autofill the function down through C78.

looking for help with the formula because my answers keep coming back negative.

In cell B39, use the CUMPRINC function to calculate the end of

B D E $218,000.00 7.2% 10 4 $7,692.29 Principal Payments Interest Payments 28 29 Loan Analysis - Option 4 30 31 Loan Amount 32 Interest Rate 33 Term of Loan (years) 34 Payments per Year 35 Quarterly Payments 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Quarter 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

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!

Record the following transactions for Winter Consulting. Explanations are not required. Apr. 15 18 25 28 28 30 Provided consulting services to Lim Bao and billed the customer $2,000. Provided...

YO16_XL_GRADER_CASE5 - Coffee 1.1 Project Description: Chloe Jants is fulfilling her long-term dream of opening a coffee shop on a busy corner of her hometown. Her town is like many others in the...

Hey please I just need you to show steps like how to do them because I dont know how to do it. PLEASE EXPLAIN LIKE YOURE EXPLAINING TO SOMEONE WHO NEVER USED EXCEL THANKS. STEPS 2-31. Step...

I need help with the formulas for these. When I put in the numbers I keep getting -$15,699 or $1.29 which are both wrong 2 3 On the LoanAnalysis worksheet, in cell B9, use the PMT function to...

AECENS ABC AG On the LoanAnalysis worksheet, in cell B9, use the PMT function to calculate the end of the month payment amount required to pay off the amount borrowed for loan option 1. Use cell...

On the CarLoan worksheet, in cell G10, use the CUMPRINC function to calculate the cumulative principle paid on the car loan. Use the data in the range E4:E6 when entering the first three arguments in...

PROJECT DESCRIPTION Emma Patterson is the owner of Wayside Driving School, and wants to expand operations into neighboring towns. To do so, she would need a loan to cover the costs of additional...

PROJECT DESCRIPTION Emma Patterson is the owner of Wayside Driving School , and wants to expand operations into neighboring towns. To do so, she would need a loan to cover the costs of additional...

On the LoanAnalysis worksheet, in cell B9, use the PMT function to calculate the end of the month payment amount required to pay off the amount borrowed for loan option 1. Use cell references instead...

The Coach Caf is a small neighborhood caf that serves vegetarian breakfasts and lunches. The owner of the caf, Keith Watson, started the caf with $50,000 of his own money. Now that hes up and...

Show that each of the following functions is a linear transformation. (a) T: R2 R2; T(x, y) = (x, -y) (reflection in the X axis) (b) T: R3 R3; T(x, y, z) = (x, y, -z) (reflection in the X-Y plane)...

You own a nonunion company with 93 nonexempt employees. All of these employees pack books into boxes for shipment to customers throughout the United States. Because of wide differences in...

3. Given are five observations collected in a regression study on two variables. xi 2 6 9 13 20 yi 7 18 9 26 23 a. Develop a scatter diagram for these data. b. Develop the estimated regression...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

5. Consider a scene from a favorite film or novel. Imagine how it would change if you had not seen the rest of the film or read the entire novel. Would you come away from it with the same meaning if...

4. Describe two communication situations, one in which the communication was appropriate but not effective, and one in which the communication was effective but not very appropriate. Analyze these...

1. LaunchPad for Real Communication offers key term videos and encourages selfassessment through adaptive quizzing. Go to bedfordstmartins.com/ realcomm to get access to: LearningCurve Adaptive...