Free Itemized Expense Report Template With Itemized Expense Report Template Plus Together With
Most Popular This Week
Look for a font that is without serifs as they are easiest on the eyes. I would stick with black type but if a cell calls for more emphasis you may want to use a different color to signify a positive or negative. Use bold and italics when appropriate to let this information stand out from the rest. These features are outstanding for titles and headings. Try to make the font as large as you can to fit in the cell. Ten point is a good and readable size. There s nothing worse than having to squint to read the information on your spreadsheet. If you can t read it chances are good that the people you re preparing the spreadsheet for won t be able to read it either.
Column Alignment Depending on your information you may want to adjust where the information falls within the column. Try left center or right and see how it reads. I generally find that numbers and dates are best centered and that text seems to work with a left justification as full sentences or phrases are read left to right. But again try the different methods and see what works best for the data that you are presenting. Allow sufficient space around the information in the cells by adjusting the column width. Excel offers a feature that allows you to double-click on the end of the cell column and it automatically adjusts to fit all of your information.
Most Popular This Week
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.