New York Finance Tutoring
New York Corporate Finance Tutor
Corporate Finance tutoring covers topics in valuation of companies, stocks, bonds, and decision making. Intermediate level uses Excel spreadsheet for financial analysis and for processing financial statements. This usually starts with financial accounting and management accounting topics. More advanced courses may use scenario analysis to investigate the impact of one variable on a company decision.
New York Financial Math Tutor
Financial Math tutoring covers topics in financial derivatives like swaps, forwards, futures and options. This uses excel for binomial trees or R in implementing Black Scholes model to value options or in other simulation procedures.
New York Financial Economics Tutor
Financial Economics tutoring covers topics beyond simple valuation. These look at the financial market in general both local or in global scale. This can be heavy in programming.
New York MBA Tutoring and Thesis Tutoring
I help Finance majors and MBA students in their thesis. This includes developing the research topic, processing data in spreadsheet and writing the results. I can also help in capstone finance.
Mortgage Calculation With Excel’s Data Table
This video is inspired by my experience interacting with a car salesman who initially acted like he’s an “expert” and then depended on his manager for basic mortgage calculations and eventually used a little mortgage calculator.
Time Value of Money – Deriving Annuity Formula for Mortgages
How to derive the annuity formula
How to use the PMT function in Excel
How to calculate the interest paid
How to calculate the remaining principal balance
How to build a mortgage table
Capital Budgeting
How to calculate NPV and IRR or a project
How to calculate the free cash flow
How to calculate the depreciation
How to calculate the weighted cost of capital WACC
How to calculate the cost of equity and cost of debt
How to calculate the after-tax salvage value