Week%207-ACC381 - CollegeofBusiness Information Systems...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Name College of Business Information Systems Management / Accounting Information Systems Lab - Financial Impact of Loans and Investment Samantha Kleitsch / Lise Urbaczewski
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Loans! Understanding interest, principal, and amortization *** note: don’t borrow money if you don’t have to!! *** Today we will discuss calculating different interest calculations What is positive and negative cash flows? ( Why is this important to a business?? ) What is meant by future value and present value? Disclaimer: This is not “Everything you need to know about Finance in an hour” Property of L. Urbaczewski / S. Kleitsch
Background image of page 2
Focus Today: 1. Today we will discuss calculating different interest calculations 2. What is positive and negative cash flows? ( Why is this important to a business?? ) 3. What is meant by future value and present value? 4. What is amortization? Property of L. Urbaczewski / S. Kleitsch
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Simple interest Simple interest = Principal * Interest rate per time period * number of time periods Compound interest First year = Principal * Interest rate Second year = Principal plus Interest accrued * interest rate Third year = ?? Property of L. Urbaczewski / S. Kleitsch
Background image of page 4
Starting with a basic file…lets calculate payment (PMT) Property of L. Urbaczewski / S. Kleitsch
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
We want to determine if we can afford our monthly payment… Monthly Payment? =-PMT(rate/12, 12*years, loan_amt) Why did I add a negative sign in front of –PMT? Total Interest? = 12*years*monthly_pymt – loan_amt Total Cost? = price + total_interest Property of L. Urbaczewski / S. Kleitsch
Background image of page 6
PMT function = PMT (rate, nper, pv, fv, type) Discuss each of these arguments (see page 362 in text) (see Fig 6.3 for example of usage) Property of L. Urbaczewski / S. Kleitsch
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Should have something like… Property of L. Urbaczewski / S. Kleitsch
Background image of page 8
Property of L. Urbaczewski /
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/07/2011 for the course ACC 381 taught by Professor Samanthakleitsh during the Spring '11 term at University of Michigan-Dearborn.

Page1 / 36

Week%207-ACC381 - CollegeofBusiness Information Systems...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online