Access Millions of academic & study documents

Sc Ex19 4a Aurkednafeaa 2

Content type
User Generated
Subject
Computer Science
School
San Diego State University
Type
Homework
Showing Page:
1/6

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/6

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/6

Sign up to view the full document!

lock_open Sign Up
Showing Page:
4/6

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 6 pages?
Access Now
Unformatted Attachment Preview
Author: Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Shelly Cashman Excel 2019 | Module 4: SAM Project 1a Smith & Lyngate Insurance CREATE A LOAN ANALYSIS Aurked Nafeaa Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. New Office Building Loan Calculator Date Property Price Down Payment Loan Amount Rate $ 3.95% 4.05% 4.15% 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05% 5.15% Loan Payment Calculator 9/15/2021 Rate 4.45% Charles Street Term in Months 180 $ 1,150,000 Monthly Payment $7,014.45 $ 230,000 Total Interest $ 342,601.29 $ 920,000 Total Cost $ 1,492,601.29 Varying Interest Rates and Terms Number of Months 7,014 120 180 $ 9,292.71 $ 6,782.10 $ 9,336.43 $ 6,828.20 $ 9,380.28 $ 6,874.49 $ 9,424.25 $ 6,920.96 $ 9,468.35 $ 6,967.62 $ 9,512.58 $ 7,014.45 $ 9,556.92 $ 7,061.47 $ 9,601.40 $ 7,108.67 $ 9,645.99 $ 7,156.05 $ 9,690.71 $ 7,203.62 $ 9,735.56 $ 7,251.36 $ 9,780.53 $ 7,299.29 $ 9,825.62 $ 7,347.39 $ $ $ $ $ $ $ $ $ $ $ $ $ 240 5,550.81 5,599.29 5,648.00 5,696.96 5,746.15 5,795.57 5,845.23 5,895.13 5,945.26 5,995.62 6,046.21 6,097.03 6,148.09 Scenarios Renovation 20 Years 8 Years Loan Amount $ 1,020,000 $ 968,938 $ 920,000 Annual Interest Rate 4.45% 4.25% 4.45% Monthly Interest Rate 0.37% 0.35% 0.37% Loan Period in Years 15 20 8 Loan Period in Months 180 240 96 Start Date 1/3/2022 1 ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4