FIN 360 Lecture Notes - Lecture 1: Alphabet Inc., Cash Flow, Net Present Value

48 views6 pages
19 Sep 2016
School
Department
Course
Professor

Document Summary

Vbas and macros: get it formula. Present value and npv: present value: the value today of a payment to be received in the future, future value: the value in the future of a sum invested today, in excel npv function = pv function. Pv and npv in excel continued: used to obtain pv of annuities only, sum the present values of each cash flow or npv function (cash flow)/(1+discount rate)annuity year. The present value of a series of cash flows is the value today of the future cash flows. The net present value is the pv cost of acquiring the assests (cf0) When finding the npv via excel function, Internal rate of return and loan tables: irr = the compound rate of return (r) which makes the npv, 0, irr function on excel. Data what if analysis: amortizing loan. Every year, you repay a certain amount of principal and make interest payment based on loan balance.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions