Tag Archives: finance

Excel Finance Class 35: Calculate PMT for Present Value of Annuity PMT Function for Loan Payment

Download Excel workbook people.highline.edu Learn how to use the PMT function to calculate a loan payment.

Excel Finance Trick #8: Complete Loan Analysis

See how to use the PMT and RATE functions for a complete Debt/Loan Analysis. Debt Analysis with input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Payment, Actual Cash Received, Adjusted APR, and PMT w Balloon Payment. In ThisSeries learn 17 amazing Finance Tricks. Learn about … Continue reading

Excel Finance Trick #12: SLN & DDB Depreciation functions

See how to use the SLN & DDB Depreciation functions. The non-cash depreciation expenses are important for finance cash flow analysis. This video shows you the SLN & DDB functions. In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions … Continue reading

Before you finance a relative’s home, think the deal through carefully

Before you finance a relative’s home, think the deal through carefully Q. My brother-in-law is going to refinance his home at a lower interest rate, and we are considering carrying the loan. The loan would be $ 150,000 for 30 years at 4 percent. The payback for the $ 150,000 would be in 17.5 years. … Continue reading

Excel Finance Class 43: Business Amortized Loans

Download Excel workbook people.highline.edu Learn how to build an amortization table for a business loan using the PMT function and a few other Excel tricks.

Excel Finance Class 42: Consumer Amortized Loans

Download Excel workbook people.highline.edu Learn how to build an amortization table for a consumer loan using the PMT function and a few other Excel tricks.

Investment Finance Tips : Interest Calculator Tips

Interest calculators help to calculate how much interest over the life of a loan a borrower will end up paying. Use an interest loan calculator correctly withtips and advice from an experienced financial adviser in this free video. Expert: Patrick Munro Contact: www.northstarnavigator.com Bio: Patrick Munro is a registered financial consultant (RFC) with outstanding sales … Continue reading

Home Finance

Home Finance Professional Android App Video Manual

Investment Finance Tips : Equity Loan Calculator Tips

Equity loan calculators help to determine how large of a loan a person should get in regards to how much their house is worth. Use an equity loan calculator correctly withtips and advice from an experienced financial adviser in this free video. Expert: Patrick Munro Contact: www.northstarnavigator.com Bio: Patrick Munro is a registered financial consultant … Continue reading

Webster’s 21st Century Personal Finance & Amortization Guide

Webster’s 21st Century Personal Finance & Amortization Guide Price: [wpramaprice asin="B000MHN8Q4"] [wpramareviews asin="B000MHN8Q4"] Related Amortization Finance Products