Excel mid
inwoodchck
MISLabExamOnline.xlsxStudents
| SENIOR HIGH SCHOOL | |||||||
| STUDENT WORK FORCE | |||||||
| Hourly Rate | 4.75 | ||||||
| HOURS WORKED | |||||||
| Name | Monday | Tuesday | Wednesday | Thursday | Friday | Total Hours | Salary Earned |
| Juan Cortez | 2.75 | 4 | 4 | 4.5 | 4 | ||
| Joe Slizewski | 2.75 | 3.5 | 3.5 | ||||
| Mici Kimura | 3 | 2.75 | |||||
| Gregg Hill | 2.75 | 2.75 | 2.75 | ||||
| Robert Babb | 4 | 4 | 4 | 4 | 3 | ||
| Karla Ford | 5 | 5 | 5.15 | 5.3 | |||
| Susan Chaney | 5.75 | 3 | 3.3 | ||||
| Andy Sanchez | 4.5 | 4.75 | 2.75 | 5.5 | |||
| Leon Jackson | 2.3 | 2.3 | 2.5 | 6 | 5 | ||
| Gina Stafford | 3.3 | 5 | 4.75 | 3 | |||
| Total | |||||||
| % of Total Hours | |||||||
| Average | |||||||
| Highest | |||||||
| Lowest | |||||||
| Total number of students |
Penalty
| TheZone Accounts Payable - Outstanding Balance Report | |||||||
| Vendor Name | Category | 30-Days Past Due | 60-Days Past Due | 90-Days Past Due | Total Past Due Balance | Apply Penalty | Penalty Amount |
| RTF Electric | Utilities | $ 16,254 | $ 0 | $ 0 | $ 16,254 | ||
| Ross County Water & Sewer | Utilities | 1,435 | 0 | 0 | 1,435 | ||
| YNC Trucking | Transportation | 0 | 0 | 3,300 | 3,300 | ||
| Italian Leather Group Ltd. | Raw Materials | 6,756 | 0 | 5,674 | 12,430 | ||
| Union Plastics | Raw Materials | 0 | 436 | 0 | 436 | ||
| Freight to Go | Transportation | 0 | 0 | 873 | 873 | ||
| Temps R'Us | Labor | 2,700 | 0 | 0 | 2,700 | ||
| Notworth Telephone | Telephone | 0 | 0 | 2,345 | 2,345 | ||
| TOTAL PAST DUE BALANCE | PENALTY | ||||||
| 0 | 0% | # of Vendors with Penalty | |||||
| 1000 | 1% | ||||||
| 2000 | 3% | ||||||
| 5000 | 5% | Value of Penalties Applied | |||||
| 10000 | 7% | ||||||
| 15000 | 10% |
Loan
| Home Loan Calculations | |||||||
| Maximum Affordable Monthly Payment | $1,800 | ||||||
| Annual Interest Rate | 6.50% | ||||||
| Compounded | 12 | times per year | |||||
| Years | |||||||
| 10 | 15 | 20 | 25 | 30 | |||
| Mortgage | $200,000 | ||||||
| $210,000 | |||||||
| $220,000 | |||||||
| $230,000 | |||||||
| $240,000 | |||||||
| $250,000 | |||||||
| $260,000 | |||||||
| $270,000 | |||||||
| $280,000 | |||||||
| $290,000 | |||||||
| $300,000 | |||||||
| Can I Afford a 20-year loan of $240,000? | |||||||
| Can I Afford a 20-year loan of $250,000? |
