Question: Please help with formulas so i can check my work. A. You have taken out a 25-year mortgage for $162,800. The interest rate is 8%

Please help with formulas so i can check my work. A.

Please help with formulas so i can check my work.

A. You have taken out a 25-year mortgage for $162,800. The interest rate is 8% and the down payment is 10%. Calrulate the monthly navment Directions: a. In Cell C8, enter a formula to compute the Down Payment. b. In Cell C9, enter a formula to compute the Amount Financed. c. In Cell C10, enter a formula to compute the $1,000 Units of Amount Financed. d. In Cell C12, enter a formula to compute the Monthly Payment. e. Format Cells C8, C9, and C12 for Currency, 2 Decimal places, and $. Format Cell C10 for Number. Set Decimal places to 2. Directions a. In Cell E24, enter the Amount Financed from Cell C9. b. In Cell B25, enter the amount of the Monthly Payment. Copy it to Cells B26 and B27. c. In Cell C25, enter a formula to compute the Interest Portion of the first Monthly Payment. d. In Cell D25, enter a formula to compute the Principal Portion. e. In Cell E25, enter a formula to calculate the Loan Balance after the first month's payment. f. Copy the formulas in Cells C25, D25, and E25 to Rows 26 and 27 to complete the spreadsheet. A. You have taken out a 25-year mortgage for $162,800. The interest rate is 8% and the down payment is 10%. Calrulate the monthly navment Directions: a. In Cell C8, enter a formula to compute the Down Payment. b. In Cell C9, enter a formula to compute the Amount Financed. c. In Cell C10, enter a formula to compute the $1,000 Units of Amount Financed. d. In Cell C12, enter a formula to compute the Monthly Payment. e. Format Cells C8, C9, and C12 for Currency, 2 Decimal places, and $. Format Cell C10 for Number. Set Decimal places to 2. Directions a. In Cell E24, enter the Amount Financed from Cell C9. b. In Cell B25, enter the amount of the Monthly Payment. Copy it to Cells B26 and B27. c. In Cell C25, enter a formula to compute the Interest Portion of the first Monthly Payment. d. In Cell D25, enter a formula to compute the Principal Portion. e. In Cell E25, enter a formula to calculate the Loan Balance after the first month's payment. f. Copy the formulas in Cells C25, D25, and E25 to Rows 26 and 27 to complete the spreadsheet

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 Accounting Questions!

Answer to the Question, Answer the one you feel you can answer Felix is purchasing a brownstone townhouse for $2,300,000. To obtain the mortgage, Felix is required to make a 19% down payment. Felix...

The Answer to the question Felix is purchasing a brownstone townhouse for $2,300,000. To obtain the mortgage, Felix is required to make a 19% down payment. Felix obtains a 25-year mortgage with an...

The Answer to the question you feel you can answer Felix is purchasing a brownstone townhouse for $2,300,000. To obtain the mortgage, Felix is required to make a 19% down payment. Felix obtains a...

1. Travis Thompson his credit card to obtain a cash advance of $600 to pay for his textbooks in medical school. InInterest rate charged for the loan is 0.05119% per day, Travis repays the money plus...

will you jusr check the msth for f & g please 94 95 g. How would the PV and FV of the annuity change if it were an annuity due rather than an ordinary annuity? 96 97 98 Use the "type" box in the...

Please show ALL of your work! Solve the following future value annuity questions. a) For a pension plan, it is required to put in $500 every 6 months into an account with a rate of 3.6%/ a compounded...

could you please help me to do those 4 questions. thank you so much. the test will be tomorrow, please be basific, thank you 6. Ava wants to save up money to buy a car in three years. She has two...

please solve using formulas not excel or financial calculator. thank you. 1) You purchase a house for $302,000 by getting a mortgage for $265,000 and paying a $37,000 down payment. a) If you get a...

Derek and Meagan Jacoby recently graduated from State University, and Derek accepted a job in business consulting while Meagan accepted a job in computer programming. Meagan inherited $66,000 from...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

Read the following question carefully, and answer what the question is asking for: "What", "When", "Why", "How Many" and provide examples where required. Sunrise Distributors recently completed a...

1. State Loopholes in the MRTP Act and Subsequent Amendments Use the editor to format your answer Question 2 "MRTP has outlived its Utility". Discuss the statement. Use the editor to format your...

The Court decided that the mistake made by Mrs Johnson in Taylor v Johnson [7.120] was a fundamental mistake of fact and the contract was rescinded. However, the mistake in Leaf v International...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

6. Describe how communication can reinforce cultural beliefs and behavior.

7. The celebration of Buddhas birthday is not held on Christmas, but instead on: a. Fourth of July b. July 14 c. Asian Lunar New Years Day d. Hanamatsuri

10. Describe the relationship between communication and power.