Mortgage Loan Worksheet
Cell Options If you look under the "Format Cells" menu that appears when you right-click on a cell or selected cells you ll see a multitude of choices as far as borders colors patterns and number options for your cells. Borders should be used to contain your data within the cells and provide nice straight lines for your readers to follow. You can emphasize headings with thicker point borders or even dashed or dotted lines. Try to remain consistent throughout your spreadsheet. If all of the headings have a three point border than continue that throughout the document.
Also how do you intend to handle depreciation and amortization since these are non-cash items that are typically added back to the income statement entries when determining the cash effect. Also how long is your investment horizon? Is it really that important to you to project out to 30 years or is 3-5 years sufficient along with a terminal value that represents the expected NPV beyond 5 years? Usually this latter approach works best and looks the most credible to potential investors. There are numerous ways to calculate terminal value including multiples current market values projected forward and round guesstimates. Obviously these decisions are affected by your personal preference and the type of investment for which you re calculating present value.
Most Popular This Week
This is a great setting when you are adding dates as well because it will place your data into whatever date format you prefer. Formulas Do not be afraid to take advantage of the formula options in Excel. You can make them as complex or as simple as you want or need. A very simple one is the SUM feature that will add a column of numbers for you and provide the total in whichever cell you specify. As the information in the cells changes the sum in the total cell will adjust accordingly. This is a great option for presenting budgetary numbers or inventory type items. There is a formula wizard which will help you string together any number of data sequences and configurations.
All the Accounts you set up for your business is called a Chart of Accounts. Recording your business financial transactions (Journal Entries) can be executed with pen and ink on an accounting columnar pad or electronically with your computer using a spreadsheet program (MS Excel Open Office Star Office). Whether you employ electronic or hardcopy media you need to develop a simple Journal template to create your Business Synoptic Journal. This Synoptic Journal format has the advantage of allowing you a complete view of all your individual journal entry transactions against all your various Business Accounts.