Given the following information: Interest Rate (yearly): 3.5% Mortgage: $250,000 Term (in months): 360 Start...
80.2K
Verified Solution
Link Copied!
Question
Accounting
Given the following information:
Interest Rate (yearly): 3.5%
Mortgage: $250,000
Term (in months): 360
Start Date: October 1, 2019
Yearly Bonus: $10,000
Formulas to incorporate:
PMT
EDATE
SUM
Other Notes:
Do amortization monthly.
Note that the interest rate is yearly and that your amortization table is monthly.
Anchoring cells will make it faster to develop your spreadsheet.
Youll want to set up your spreadsheet to have the following columns: Starting Balance, Interest Accrued, Payment, Principal, Ending Balance, Cumulative Interest, Cumulative Principal.
Case:
What is the minimum payment each month?
Scenarios (complete each scenario on a separate tab and label each tab appropriately):
- Pay the minimum required.
- Pay an extra $250/month. When will you have the loan paid off by?
- Pay an extra $250/month and make a larger payment (equal to 50% of your year end bonus) each December. When will you have the loan paid off by?
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.