Insert a calculated column using the PMT function to calculate the monthly payment for each of the properties. In column H, insert a calculated column using the IF function to determine the amount of the if discount property qualifies for it.
Week 8 Final Project The Scenario: Tony Spacken, Sales Manager, has an Excel workbook listing properties for sale. If a property is sold, Select National Properties Group will finance the property loan for 30 years at 7.5% interest. If the monthly payment of a property is greater than $300,000, the company will give the buyer […]