Computing a Loan Payment & Creating an Amortization Schedule
Computing the Periodic Payment for a Loan Excel Financial Function Computing the periodic payment is probably the most used Excel financial function simply because it is something everyone uses.Let’s walk through an example.You want to purchase a car and finance...
Dupont Model
Dupont Model The DuPont Model is a methodology that computes Return on Equity by component parts. Business owners and shareholders are very interested in their level of return. A method of consulting with business owners and shareholders on ways to boost Return on...
Conditional Formatting-Icons
Using ICONS- Conditional Formatting When I started writing my Excel Driven Dashboard course a couple of years ago I really started appreciating a more visual approach to Excel. Now I am always incorporating color and images into spreadsheets wherever possible. So, to...
Using the Altman Z Score to Predict Bankruptcy
Using the Altman Z Score to Predict Bankruptcy – Guest Post by Joe Helstrom, CPA Background: The Altman Z score for bankruptcy prediction was first published by Edward Altman, an Assistant Professor of Finance at New York University, in...
Password Protect an Excel Workbook
How to password protect an Excel workbook Everything these days seems to require a password.. and of course everyone has different specifications. I would love to hear from people on how they safeguard their passwords. Send me an email with your method- send to...
Using Workday to Calculate Invoice Dates
This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project completion date use the WORKDAY() function. Select a cell and then select the Formula tab and then select Date& Time The syntax is as...Repair Regulation Relief – Relief or Stomach Ache?
The IRS has revamped the tangible property regulations for the 2014 tax year. The new procedure allows small businesses to change a method of accounting under the final tangible property regulations on a prospective basis for the first taxable year beginning on or...
Preventing Duplicate Entries using Data Validation in Excel
If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data. Let’s assume that the data...