Question
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
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 as 7.5% interest. If the monthly payment of a property is greater than $3000,000 the company will give the buyer a 1% discount on the selling price.
Assignment:
Calculated the column using the PMT Function to calculate the monthly payment for each of the properties. Then insert a calculated column using the IF function to determine the amount of the discount if the property qualifies for it.
I need the formulas in excel
| Property | Address | City | State | ZIP | Selling Price | Month Payment | Discounts |
| Albuquerque Technical Training | 789 W. Main St. | Albuquerque | NM | 87110 | $ 604,500 | ||
| Alvarado Surgical Center | 106 E. 1500 N. | Rugby | ND | 58368 | $ 53,999,000 | ||
| American Service Industry Fulfillment | 1401 Mother Lode Cir. | Port Huron | MI | 48060 | $ 751,500 | ||
| Arbor Square Shopping Mall | 4980 Hwy. 14 E | St. Louis | MO | 63122 | $ 6,390,000 | ||
| Arden Wood Medical Center | 306 W. Central Ave. | Arlington | TX | 76012 | $ 68,433,000 | ||
| Arizona Surgical Hospital | 42 W. 35th Ave. | Ulysses | KS | 67880 | $ 55,500,000 | ||
| Arroyo Grande Rehabilitation Hospital | 500 NW Cheyenne | Salem | NH | 03079 | $ 75,520,000 | ||
| Aston Office Solutions Warehouse | 2211 SE 16 St. | Battle Creek | MI | 49017 | $ 6,230,000 | ||
| Austin & Ball Warehouse | 712 E. 108th Ave. | Paterson | NJ | 07514 | $ 9,189,500 | ||
| Ballyhoo Office Building | 4161 N. 1500 W. | Green Bay | WI | 54305 | $ 5,675,000 | ||
| Barton, Oaks & Colina Building | 1119 NE Thorn Hill Rd. | Jefferson City | MO | 65101 | $ 5,460,000 | ||
| Belmar Group Warehouse | 30 Imperial Way | Bolivar | TN | 38008 | $ 4,900,000 | ||
| Bergstrom Industries Warehouse | 209 Elice Cir. | Littleton | CO | 80122 | $ 7,326,000 | ||
| Best Electronics Manufacturing | 8692 Technology Blvd. | Berkeley | MI | 48072 | $ 6,030,000 | ||
| Bloomington Hospital | 843 Fayette Ave. | Amarillo | TX | 79106 | $ 60,450,000 | ||
| Boulder Community Training Services | 176 Van Buren St. | Boulder | CO | 80026 | $ 848,900 | ||
| Broaddus Surgical Center | 145 Tudor Dr. | Waterloo | IA | 50702 | $ 68,150,000 | ||
| Broatman Hospital | 22161 N. Randolph Dr. | Auburn | WA | 98001 | $ 47,146,000 | ||
| Builder Supply Warehouse | 103 Cleveland St. | Elkhorn | WI | 53121 | $ 6,412,000 | ||
| Cardman Facility | 100 Linden Ln. | Rock Springs | WY | 82901 | $ 3,980,000 | ||
| Casa Mesa Regional Medical Center | 926 Camino Blvd. | Inglewood | CA | 90301 | $ 81,950,000 | ||
| Cayeta County Educational Services | 6921 1st Ave. W. | Brookfield | WI | 53045 | $ 597,500 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Establishing A CGMP Laboratory Audit System A Practical Guide
Authors: David M. Bliesner
1st Edition
0471738409, 978-0471738404
