PLEASE SOLVE ONLY USING EXCEL Samuel agreed to pay $550,000 for a house. He made a...

PLEASE SOLVE ONLY USING EXCEL

Samuel agreed to pay $550,000 for a house. He made a $125,000 down payment and financed the balance using a 30-year, 6 % per annum compounded monthly conventional loan.

a) How much were his monthly payments? b) If he sold the house for $750,000 after 5 years, how much equity did he have in the house? c) How much is his contribution to his loan (Principal and Interest)?

Expert Solution

jeff jeffy answered 5 days ago

John purchased a new house for $500,000. He paid 20 percent down and agreed to pay...

John purchased a new house for $500,000. He paid 20 percent down and agreed to pay the rest over the next 25 years in 25 equal annual payments at 6 percent compound interest. What will be his annual payments?

Please outline each step used along the way to solve the problem using excel only with...

Please outline each step used along the way to solve the problem using excel only with cell numbers and formulas used. Thank you. Whenever an Alliance Air customer flies on a prepurchased seat, Alliance Air obtains $100 in profits. However, if Alliance Air has more customers seeking a seat then they have prepurchased, Alliance Air is forced to book that passenger on a seat purchased that day. In such a situation, Alliance Air has a profit of -$170 due to...

PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial...

PLEASE SOLVE IN EXCEL WITH CALCULATIONS AND WORK. A mortgage for $100,000 is made with initial payments of $500 per month for the first year. The interest rate is 9 percent. After the first year, payments will increase to an amount that makes the loan fully amortizable over the remaining 24 years with constant monthly payments. a. Calculate the interest deductions for the loan for the first year. b. How much, if any, interest must be deferred until the second...

*SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED**** A company is considering...

*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...

Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$ 26,500 Units started during April ......................................................................................................................................100,000 Units...

Please solve using excel. If 200,000 is available for investment and 60,000 is invested at 20%...

Please solve using excel. If 200,000 is available for investment and 60,000 is invested at 20% per year with the remainder is invested at 12% per year. What is the overall rate of return on the 200,000?

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

How can I solve this in Excel? Please show how to solve it in excel step...

How can I solve this in Excel? Please show how to solve it in excel step by step. 1) Speedy Wheels is a wholesale distributor of bicycles for the western United States. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model — a small, one-speed girl's bicycle that is selling at the rate of 250 per month. The administrative cost for placing an order for this model from the manufacturer is $200 and the...

Jess has agreed to purchase a house on 11th Street by July 2020 but only if...

Jess has agreed to purchase a house on 11th Street by July 2020 but only if she is able to sell her house on 15th Street by June 2020. This term is called a: express condition concurrent condition condition subsequent anticipatory condition --------------------------------------------------------------------------------------------------- In the United States, sources of law include: Executive orders laws passed by a state legislature international common law the U.S. Constitution --------------------------------------------------------------------------------------------------- The main purpose of contract remedies is to put the party who is not...

Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter...

Please use Microsoft excel. Using a Nested Loop, what is the equation to solve for letter grade Nested loop Student ID Grade Letter Grade 1 5 If score is Then return 2 55 Greater than 89 A 3 86 From 80 to 89 B 5 64 From 70 to 79 C 6 25 from 60 to 69 D 7 56 less than 60 F 8 58 9 99 10 90 11 28

Question