101 Highlights the cells that require you to enter data
102 Insert Sample Data
103 Replaces ALL the sample data, even if you changed it
104 Remove Sample Data
105 Deletes ALL the sample data, even if you changed it
106 Save a Version
107 Stores a version of the document so you can compare results
108 Open a Version
109 Retrieves a version of the document so you can compare results
110 Print Preview
111 See the document as it will print
112 Print
113 Sends the document to the current printer
114 Save
115 Lets you name and save the file
116 Added Payment Mortgage
117 The form assumes that you will make the additional payment each month with your normal payment. By doing so, your additional payment is immediately applied to principal and therefore accelerates the payoff of the loan balance. Check with your lender for any prepayment penalties.
118 Auto Expense Report
119 The dates in the report are calculated from the "Ending Date" field. If you wish to use a period of time other than one week, make individual entries in the date and odometer reading columns.
120 7 Year Balloon Loan
121 A balloon loan requires a large final payment at some future date. The advantage of such an arrangement is that the borrower makes payments based on a traditional mortgage term, at an interest rate that reflects the typically lower annual rate of a shorter-term loan (7 years).
122 Balloon Payment Loan
123 In a balloon loan, the borrower makes payments like a long-term loan. For example, you could have a five-year balloon loan with monthly payments based on a 15-year loan. However, at the end of five years, you will have a final large payment due.
124 Bank Reconciliation
125 Enter your name, the bank, and the account number in the spaces provided. Then enter the balances from your bank statement and checkbook. Finally, enter the outstanding checks.
126 The par value is the face value or redemption value of the bond, the amount the bond issuer has promised to cash the bond out at on some future date. The years to maturity equal the number of years that remain until the bond is cashed out. The required rate of return is the investors expectations for an annual yield from the investment while the coupon rate is the annual interest paid on the bond, as a percentage of the bond's par value.
127 Basic Bond Valuation
128 Biweekly Mortgage
129 This bi-weekly amortization assumes that the borrower will make 26 payments per year, as opposed to a traditional mortgage where 12 payments per year is the norm. The project is designed to accept up to 30 years as a loan term.
130 Buy vs. Lease a Car
131 The discount for present value and the cost of borrowing are different, though they could be equal. The tax consequences of a lease and a purchase may be decisive and will vary in each instance, so you should see your tax advisor. The Lease Term is the duration of the lease in months.
132 Enter data in the appropriate columns. Net Proceeds means the actual amount you realize from a sale, not the price for which you sell.
133 Capital Gains and Losses
134 Car Lease Calculator
135 Since payment factors are developed by the dealer, discuss such residual and money factors. The residual value can be estimated as follows: .65 for 2 years, .57 for 3 years, .49 for 4 years, and .41 for 5 years. Since payment factors vary by dealer, you can estimate the residual value: .65 for 2 years, .57 for 3 years, .49 for 4 years, and .41 for 5 years. Estimate the money factor by dividing the current new car loan rate by 2400.
136 Cash Budget
137 Change the starting month by typing the first three letters of the month at the top of the first column. Note that the total column summarizes the entire year, from the first month's beginning balance to the last month's ending balance.
138 When seeking higher CD yields, consider the opportunity cost of switching from a lower-yielding CD that carries a penalty for early withdrawal to a higher-yielding CD. This analysis works only if you are switching to a CD with a life equal to or greater than the number of months remaining on the current CD.
139 CD Switch Analysis
140 Closing Costs
141 The project is not meant to replace the official HUD settlement form used at a real estate closing. Rather, it is a working model that you can use as a checklist for your own information and to prepare for the closing.
142 College Costs
143 Enter percentages as decimals (.06 for 6%). Some data applies to all children (such as the inflation rate), while some can be applied to each child. Current savings, however, must be assigned individually.
144 Consumer Loan Proceeds
145 You might also want to include a projected report as part of your loan application since that information is useful to the loan officer when evaluating your loan request.
146 Consumer Debt Consolidation
147 The monthly pre-tax cash flow savings is the difference between your current consumer debts and the "new" home equity loan payment. The worksheet does not account for the savings on deducting the home equity interest.
148 Consumer Debt Manager
149 Consumer debts are personal loans, credit cards, and other obligations other than your home mortgage. As a rule of thumb, you should keep your monthly consumer debt payments to no more than 15% of your monthly take-home pay.
150 The form can be filled out on paper or electronically. However, since very little will likely change from year to year, it will save time to maintain the data in the spreadsheet.
151 Credit Card Log
152 Time Sheet
153 The form calculates the difference between start and stop times. This is an excellent form for professionals who track their time on various assignments and clients.
154 Specify whether the deposit will be made at the end of the year (Ordinary Annuity) or at the beginning of the year (Annuity Due). Enter the amount you want your investment to grow to (Amount to be Accumulated), the number of years it will take to meet your goal, and the annual rate of return you expect on your investment (Annual Interest Rate).
155 Deposits to a Sum
156 Disability Insurance
157 The analysis is a "what-if"--what if a breadwinner cannot work because of a disability? Will other income sources be sufficient? Do the analysis for each of the "wage earners" in your household.
158 Discretionary Income Plan
159 This worksheet helps you get a handle on expenses. You enter the dollar amounts of the expenditures, and the percentages will calculate automatically.
160 Estate Liquidity Analysis
161 You can use this worksheet for two people to determine if the liquid assets will be sufficient to cover final expenses upon each of the deaths. For large estates, you need to estimate both Federal estate taxes and State death taxes.
162 Expense Report
163 Change the mileage reimbursement rate, by double-clicking the cell to the right of "Reimbursement." Enter the ending date of the week in the cell labeled "Period Ending."
164 Financial Calculator
165 Future Value of an Annuity is the future value of a series of periodic investments of an equal amount. Annuitizing a Future Amount is the equal periodic payments that you could withdraw from an investment. After- tax Real Rate of Return on Investment is the annual return on your investment after taxes and inflation have been taken out. Tax-free Equivalent Yield converts a taxable return to an after-tax return. Taxable Equivalent Rate for Tax-free Yield converts a tax-free yield, such as that of a municipal bond, to a taxable yield so you can comparison shop for yields.
166 The planner compares the 401K wealth accumulation to the growth of a taxable savings plan. The forecasted monthly income during retirement is pre-tax. Your after-tax retirement income will depend on the marginal tax rates at that time.
167 401K Planner
168 Future Value of a Lump Sum
169 Calculate the future value of a lump sum amount.
170 Gain on the Sale of a Home
171 This worksheet calculates the tax due on a sale if the new home costs less than the sale price of the old home. Check with your professional advisors as to whether should use the "over age 55" capital gains tax exclusion.
172 Grading Sheet
173 The grade tables at the top of the notebook can be customized to fit your needs or the rules of your school. You can also assign weights (proportions) to be factored into the student's final average for the course.
174 Home Equity Comparison
175 Before you decide which lenders to submit an application: compare the fees, annual percentage rates, closing costs, and repayment arrangements. Use this with the "Home Equity Qualification" project.
176 Home Equity Qualification
177 Talk to your bank to get the information you need for the "Assumptions" section, then fill in the rest.
178 Home Rent or Buy Analysis
179 Enter an assumption for each variable for this analysis to be complete. The after-tax rate of return on investments can be estimated by multiplying your pre-tax expected rate of return by your marginal tax rate (your combined federal and state income tax rates).
180 Investment Record
181 Enter the asset type and the purchase details, including the date the asset was acquired, the number of shares (or other units) acquired, the price per share (or unit), and the broker fee. Finally, when you enter the current per unit quote, all gains and losses will calculate.
182 Job Estimate
183 Enter the customer's name and address in the box marked "To:," enter a description of the job in the space provided, then complete the itemized estimate.
184 Kiddie Tax Analysis
185 The Kiddie Tax rules apply to children under age 14 as of January 1 following the close of the tax year and who have more than $1,300 (as of 1995) of investment income. The investment income in excess of $1,300 is taxed at the parent's marginal tax rate. The child's marginal tax rate is the rate at which another dollar of earnings (of any type) will be taxed by the IRS.
186 It assumes that in the event of the death of a family wage earner, the debts will be paid, a fund will be set up to shore up any current cash flow deficit, and dollars will be invested for four years of post-secondary education. It also assumes that 75% of the pre-death living expenses will be needed by the survivors.
187 Life Insurance Needs
188 Maximum Loan Amount
189 You can calculate the maximum loan amount for three loan scenarios that are based on common assumptions such as affordable payments, term, and interest rates.
190 Monthly Auto Expense Report
191 By entering odometer readings, the mileage reimbursement rate, and specific auto expenses, you can use this form to keep a detailed monthly expense report.
192 Mortgage Amortization
193 The Amortization Schedule is in two parts--a monthly table for the first 12 months and an annual schedule for the remaining life of the loan. It also calculates several key figures; including annual loan payments, monthly payments, interest paid in the first calendar year, interest paid over the term of the loan, and the sum of all payments over the term of the loan.
194 Mortgage Qualifications
195 Set the precision by entering 1, 10, 100, or 1000 in the Precision input cell. Each lender sets different requirements, so this worksheet identifies a range for which you may qualify, not a specific mortgage loan amount.
196 Mortgage Refinancing
197 This project compares the current and proposed mortgage, including the number of months to recover the refinancing costs, and the net interest savings or costs.
198 Mutual Fund Analyzer
199 Enter the amount invested and the load (percent) charged by the mutual fund. The load charge is a sales commission that can be found in the prospectus. The load, the net amount invested, and the percentage the fund must appreciate to break even will be calculated.
200 Mutual Fund Costs
201 The cost data can be found in the fund's prospectus. The estimated holding period and the discount rate to calculate the present value of the fees are inputs. Use a reasonable holding period such as five years and a discount rate similar to what you could earn on a liquid asset account.
202 Personal Budget
203 This budget includes many categories of income and expenses and can be customized to suit your needs. Monthly figures and percentages are calculated automatically.
204 Portfolio Allocation
205 The percentage you should invest in equities (stocks) is 100 minus your age. The remaining percentage should be invested in bonds. Investment allocation should be done with consideration of your risk tolerance and tax situation.
206 highlights the cells that require you to enter data
207 Deletes ALL the sample data, even if you changed it
208 Present Value Annuity
209 Specify whether you are working with an Ordinary Annuity (payments made at the end of the year) or an Annuity Due (payments at the beginning of the year).
210 Present Value of a Lump Sum
211 This worksheet calculates the interest rate (or discount rate) if you know the present value, future value, and number of periods.
212 Property and Estate
213 Enter estimated values in the "Estimated" column first. Enter the amounts owned jointly and individually in the "Joint" and "Self" columns. The amount remaining is owned by your partner and will be calculated in column I. When the worksheet displays NA or "Estimate?," it means that the columns do not balance. That may happen when you first enter or change data in the Estimate column.
215 Real Rate Calculator
216 The marginal tax rate that you enter should be your combined federal and state tax rates. For example, if your federal rate is 36% and your state rate is 10%, then enter 46%. If you are unsure as what you should enter for the inflation rate, experts agree that an annual rate between 2% and 5% is reasonable, barring any long-term high inflationary cycle.
217 Real Rate of ROI
218 The real rate of return is the yield, less taxes and inflation, indicating the impact the investment had or will have on your wealth. Use this worksheet to calculate the real rate that you have already experienced on an investment, using historical data, or to project the real rate of return on your investments.
219 Retirement Budget
220 The field called "Annual income to be made up" can be used in the Retirement Income Plan. Enter this figure in "Annual retirement income required" in the Retirement Income Plan project.
221 Retirement Income Plan
222 Update your assumptions about inflation and earnings on a regular basis. The term "expectancy" is defined as the number of years you expect to live after retirement. The "Deposits per year" field allows you to choose income streams by week, month, and so on. Match this to the interval of your deposits.
223 Retirement Plan Contributions
224 The maximum that you are allowed to contribute to a tax deductible plan is a percentage of earned income (adjusted net business profit less the contribution).If you are self-employed and you want to contribute to a SEP-IRA, the maximum contribution is 15% of earned income, which is the equivalent of 13.04% of adjusted net business profit.
226 Running Log
227 Click the button in the upper right portion of your screen to enter the month and year. Enter miles and minutes as values to ensure that the miles/minute calculation is performed correctly.
228 School Budget
229 Enter data in the Budget and Actual columns. The worksheet will automatically calculate the budget.
230 Service Invoice
231 Note that this invoice can use a sales tax on parts and labor. If you don't collect a tax, enter zeros (0) by clicking the button in the upper right portion of your screen.
232 Estimating Startup Capital
233 The estimated cash needed to start the business is a multiple of costs for the month. The multiples are in the formulas in the "Cash Needed to Start" column. They are adapted from a U.S. SBA worksheet.
234 Year End Tax Plan
235 The worksheet has all the major elements of the IRS Form 1040. By filling out this worksheet you can keep track of the taxable income you have already earned and the estimated taxable income yet to be earned before year end. If you revise this form every month or two, you will assure that you will not incur an underpayment of income tax penalty.
236 Statement of Cash Flows
237 The Statement of Cash Flows, formerly called the Sources and Uses of Funds Statement, shows the cash inflows and outflows in three important areas: operations, investing, and financing. When entering cash flows, be sure to enter a negative number for any amounts paid.
238 Statement of Net Worth
239 The version shown here may be more detailed than you need, but it is easy to adapt.
240 Trade Show Budget
241 Enter your budgeted expenditures as well as actual expenses. Formulas calculate the variances. Unfavorable variances are shown as bracketed numbers.
242 Vacation Budget
243 You can use this worksheet to compare the costs of several vacation alternatives by storing each as a version. Enter data in the Budget and Actual column.
244 Wedding Budget
245 The only data that has to be entered is the year for the calendar and a subtitle such as your company name. You can enter any year after 1900 and up to 2100.
246 Year Calendar
247 Future Value Annuity
248 You specify whether you are working with an Ordinary Annuity (payments made at the end of the year) or an Annuity Due (payments at the beginning of the year).
249 Create Chart
250 Create a new chart
251 Create Map
252 Create a new map
253 Create Graphic Text
254 Create text graphically so it can be moved and sized above the notebook
255 Create Shapes/Lines
256 Draw arrows, lines, and shapes that can be moved and sized above the notebook
257 Create Slide Show
258 Create a new slide show
259 Insert Graphics
260 Insert a Graphic image
261 Add Graphics
262 Specify a graphic, then drag to create the box or shape. From the scrapbook, simply drag images onto the notebook.
263 More Help on
264 Insert
265 Insert rows, columns, or notebook sheets
266 Make Columns Fit
267 Adjust the selected columns to the width of its widest cell
268 Specify Column Width
269 Specify column width exactly
270 Specify Row Height
271 Specify row height exactly
272 Delete
273 Delete rows, columns, or notebook sheets
274 Adjust to Fit
275 To insert a notebook sheet, right-click the sheet tab then click Insert Sheet.
276 Select columns or rows before choosing options.
278 Displays the previous panel
279 Calculate in Cells
280 You can type numbers in cells for simple math calculations (2+2), or you can enter cell references and create formulas.\n
\n
To add, subtract, multiply, and divide, simply type the numbers and math operators in the cell, then press Enter.\n\nFor example, type 4+4 to get 8 or 4*4 to get 16.\n\nWhen you type the / symbol (divide), Corel Quattro Pro assumes you are typing a date if it looks like a date. To divide a number that looks like a date, type + in front of the number (+4/4 equals 1).
281 Change Font Properties
282 Change the look and size of text and numbers. Also Add underlining and double underlining.
283 Center and Align
284 Center and align data in cells, plus join cells
285 Add Background Color
286 Change border and background fill colors
287 Create Cell Lines
288 Change the line drawing in and around selected cells
289 Format Numbers
290 Change the format style of text in the selected cells
291 Change the Look
292 Another way to work is to select options on the Property Bar, which displays the options you need when you need them.
293 Select cells, then choose options.
294 Enter Text
295 Create headers and footers, check your spelling as you work and more
296 Enter Numbers
297 Tips on entering numbers
298 Select Cells
299 Tips on how to select cells in order to make changes to those cells
300 Move Data
301 Tips on moving data to a different location
302 Align Data
303 Change the vertical and horizontal alignment
304 Enter and Move Data
305 Click a cell, then type text or numbers. To change part of a cell, click the cell twice.
306 Change Number Format
307 Change how numbers are formatted in the selected cells
308 Insert Current Date
309 Enters the current date at the insertion point
310 Do Simple Math
311 Calculate in cells or create simple formulas
312 By default, numbers are right aligned in the cell and the cell is formatted for general numbers. If you want to format for currency or time, for instance, click Change Number Format.
313 Select cells to change number format.
314 Create Headers/Footers
315 Create a repeating line at the top or bottom of every printed page
316 Create Text in a Box
317 Create text in a box that can be moved, sized, and rotated above the notebook
318 Create TextArt
319 Create text in shapes and add colors and textures
320 Create a Comment
321 Create a comment on top of the notebook that does not print
322 QuickCorrect On/Off
323 Highlight spelling mistakes as you type
324 When typing in cells, press Enter to enter data down a column. Press Tab or arrow keys to enter data across a row.\n\nTo enter more than one line in a cell, press Alt+Enter.
325 Click anywhere in the notebook then choose the following.
326 Click the cell where you want to insert a comment.
327 Check Spelling
328 Check your notebook for typos and spelling mistakes
329 Save Notebook
330 Save your notebook as a new file
331 Print all or part of the notebook
332 Publish to Barista
333 Publish your notebook to Corel Barista
334 Clear Values
335 Clear the currently selected values but leave the formatting
336 Finish
337 Save your file frequently as you work. When you are done, check for spelling errors, then save and print. To save the formatting only, select the cells you want to clear, click Clear Values, then save or print your file.
338 Insert Text Box
339 Create a text box you can use for a thank you message, contact area or message area
340 Insert Signature Line
341 Insert a signature line in selected cells
342 Format Closing Area
343 Create interesting titles by joining cells, centering text, and using various font properties. Or use TextArt to contour text in fancy shapes.
344 Click the following, then drag and size the box where you want it.
345 Click where you want to create a signature line.
346 Join and Center
347 Join several selected cells to make one large cell
348 Create an area for a return address, send to address, or message box
349 Insert Current Date
350 Insert the current date at the insertion point
351 Format Title Area
352 Select the cells you want to format.
353 Click the following, then drag and size the box where you want.
354 Set Up the Notebook
355 Choose the basic look of the spreadsheet
356 Enter text in different ways, then move, center, or align it
357 Change the appearance of text and cells
358 Insert and size rows, columns, and sheets
359 Add pictures, fancy text, shapes, charts, maps, and slides
360 Work with Data
361 Sort and find data, plus build complex formulas
362 Check spelling, save, and print your document
363 Calculate in cells or create simple formulas
364 Quattro Pro
365 A spreadsheet is an electronic ledger pad or notebook. It contains columns and rows where you enter, arrange, calculate, and analyze data.\n
\n
Click Start to open a new blank notebook, start a template, or open an existing file.
367 Move and Copy
368 You can move or copy the contents and formatting of any cell or group of cells.\n\nSelect the cells you want to move.\n\nPoint to the edge of the selected cells.\n\nWhen the pointer changes to four arrows, drag the cells to the new location.\n\nTo copy the cells, press Ctrl while dragging.
369 Click the page to increase the view. Right click the page to decrease the view. With dashed lines turned on, drag the dashed lines to change margins.\n\nTo close Print Preview, click the printer button with an X on it, at the right end of the toolbar.
370 To change the appearance of existing data, you first need to select the cells.\n\nTo Select\nOne cell, click that cell.\n\nPart of a cell, double-click the cell then drag to select data.\n\nAn area, drag across the cells.\n\nAn entire row, click the row button.\n\nAn entire column, click the column button.\n\nTo drag, click and hold down the left mouse button, then move the pointer.
371 Change Page Setup
372 Select a paper size
373 Format the Title Area
374 Insert formatted title areas
375 Format the Table Area
376 Quickly add shading and cell lines to a new or existing table
377 Format the Closing Area
378 Insert a message box and other closing elements
379 Change View
380 Change between page and draft view to see and adjust page breaks and margins
381 Zoom
382 Change the size of the viewing area
383 Set Up Notebook
384 To see and adjust margins and page breaks, work in Page View. Use a zoom factor of 50 or less to see an entire page.
385 Simple Formulas
386 Entering formulas can be as simple as using cell references (A3...A5) and typing common math operators (+-*/).\n\nOr it can be more complex and include @functions. @functions are built in commands that let you do a variety of tasks in general math and logic, engineering, finance, and statistics.
387 Try Different Scenarios
388 Try out existing formulas on different data possibilities
389 Consolidate Groups
390 Create a formula which adds or combines values from two or more cell groups
391 Tips on typing simple math problems in cells
392 Total Columns && Rows
393 Find the total of selected columns and rows
394 Enter Simple Formulas
395 Tips on entering simple formulas
396 You can type numbers and formulas in cells manually, or you can use Quick Math to enter formulas for you. For example, you can find the average of a column or row of figures. Or you can click Two-Column Quick Math to multiply the items in one column with the items in another, such as Quantity times Unit Price.
397 QuickSum
398 Totals the values
399 Total Columns and Rows
400 QuickSum inserts a formula for you. You can also drag across numbers, then click QuickSum.
401 Click in the empty cell at the bottom of a column or at the right end of a row.
402 Sort
403 Order columns and rows alphabetically or numerically
404 Turn QuickFilter On/Off
405 Create a button that lets you display, hide, and sort items in columns
406 Find and Replace
407 Search for words or numbers and replace them with other words or numbers
408 Create a Budget
409 Create a budget for personal use
410 Analyze Data
411 Calculate mortgage payments, rank and percentile, amortization, and more
412 Build Formulas
413 Use the Formula Composer to create complex formulas
414 Use a QuickFilter to sort and filter long columns of data. Click in your data, then click Turn QuickFilter On.
415 Replaces ALL the sample data, even if you changed it
416 Ad Media Expenditures
417 The totals for each category, totals for the year, and the grand total for the advertising expenditures for a 12-month period are calculated. Enter the name of the first month in the first column, and the remaining month names will automatically adjust.
418 Direct Advertising Effectiveness
419 Enter a description of the project and the particular market that you are targeting. Then enter the "drop" -- the number of pieces of mail, items distributed, cold calls made, etc. -- for the project.
420 Average Selling Price Analysis
421 The average selling price on products is useful in situations where product pricing is not uniform across all customers because of cash discounts, quantity discounts, promotional activities, and the timing of purchase contracts in rapidly fluctuating markets.
422 Break-Even Analysis
423 At the break-even point the company does not produce a profit or a loss -- it simply earns just enough revenue to cover all costs. When entering the variable cost data, keep in mind that it is per unit data while fixed costs are totals. If you want to know the level of sales needed to achieve a particular profit, you can enter the target operating income for the period.
424 Sales Channel Analysis
425 Enter annual sales volume in both units and dollars for each of your major distribution channels. Each channel's sales is calculated as a percentage of the total sales. Average monthly volume is also calculated, as a simple average (total divided by 12).
426 Commission Report
427 Create one for each salesperson.
428 Direct Marketing Analysis
429 For some mailings, you may know the total cost of each mail unit but not know the breakdown costs for the individual components. In this case, simply enter the total unit cost into the "other" calculation cell, then enter the label "Total cost" in the cell to its left.
430 Media Forecast
431 The template includes categories for Radio, Magazine, Direct Mail, and so on. Feel free to change the categories as it suits your needs.
432 Media Budget by Quarter
433 The last part of the report shows the percentage of the total media budget spent in each quarter.
434 Quarterly Marketing Budget
435 The percentage shown for each specific expense is the percentage of the total expense for that category.
436 Marketing Personnel Expenses
437 The column for units is a headcount column or what some firms call full-time equivalents (FTEs). One unit is the equivalent of a full-time employee. The budget is for six months; you can specify any starting month by entering the first three letters of the month in the first column heading. The other column headings will adjust automatically.
438 Moving Average Sales Forecast
439 Moving averages are sometimes useful in spotting trends; however, it should be used with other forecasting techniques since past experience is not always an indicator of future experience. A moving average works by "dropping off" the oldest data. You can use any starting month by entering the first three letters of the month in the first month cell.
440 Monthly Sales Projections
441 New Product Sales Forecast
442 The probabilities that you assign are quite subjective and are based on your view of the future, your level of optimism, and your intuition.
443 Product Sales Goals
444 Begin by entering the date and by specifying whether the analysis is in dollars or units. Next enter the names of the products or lines you'll be analyzing. The totals and change are calculated automatically.
445 Product Line Sales
446 Type the date into the space provided, then type the product descriptions in the left-most column. You may then enter forecast and actual data for the current month, the year to date, and the estimated year-end. Variances are calculated automatically.
447 Sales Promotion Expenses
448 The section entitled "Other Promotions" allows you to plug in your projections for miscellaneous activities. The totals for each category, totals for the year, and the grand total for the promotional budget are calculated.
449 Sales Activity Report
450 Included in this template are sales and profit measures, selling cost, activity, and account information. This form is intended to be filled out electronically. Percentages and averages are calculated automatically.
451 Sales Trend Analysis
452 You can change the column header to the forms Q2, Q 2, Quarter 2, or Qtr 2. The template takes the number from the rightmost character, increments it (wraps at 4), and appends it to the text that precedes the number.
453 Sales Seasonality by Month
454 The Company Index to the average shows what percentage a particular month's sales are of the average month sales amount. The Industry Index to the average shows that same relationship for the industry as a whole. By comparing the two indices, you can determine if your sales are as seasonal as the industry.
455 Store-To-Store Sales
456 This template summarizes store sales by market, shows the change from last year's volume, and provides an indexing of average store sales per market. The index uses as its base the average sales per store for the system.
457 Telemarketing Report
458 Accounts Receivable Aging
459 Because many businesses maintain their accounts receivable in a database, you may wish to use file-linking formulas to reference the appropriate figures from another file.
460 Credit Control List
461 Information recorded includes the account number, account name, the date opened, details of the credit line and payment history. Maintain the form to save time and energy. It can be used on paper or filled in electronically.
462 Customer Ledger
463 After you have created a ledger for each customer, you will have the beginnings of a customer order data base. This project contains no calculations.
464 Expense Budget
465 The worksheet compares estimated and actual expenses and may be filled out in two steps. Enter the company or department name and the date in the spaces provided. Then enter the remaining information in the cells provided. The worksheet automatically calculates the dollar and percentage difference between estimated and actual figures.
466 G-A Expense Budget
467 Fixed expenses generally are stable over the course of the year, while variable expenses change with the level of activity. Variances and totals are calculated automatically after data is entered in the template.
468 Insurance Coverage
469 Begin by changing the starting month by typing the first three letters of the month in the first month heading cell. The other month headings will be automatically calculated by formulas.
470 Inventory
471 When you use the template for taking a physical inventory, enter data manually in the item, description, and unit columns. Later, when you transcribe the manually entered data, you can add the unit price data on the worksheet, which will perform the extension calculation automatically.
472 Invoice Record
473 In effect it is a database of your transactions with that vendor. It also lets you keep track of why you deducted payments from an invoice.
474 Merchandise Plan
475 The opening inventory balance is entered in the first month and calculated for all subsequent months. Note that the total column summarizes the entire year, from the first month's opening inventory to the last month's closing inventory. Change the starting month by typing the first three letters of the month in the month heading cell. The remaining months will be automatically calculated by formulas.
476 Parts Inventory
477 The worksheet contains calculations for extensions.
478 Perpetual Inventory Control
479 Be sure to enter the sheet number; the amount that should be carried forward to the next sheet and the next sheet number are at the bottom of the template.
480 Account Statement
481 Enter all dates as labels. Enter a charge or credit on each line available. To ensure an accurate balance, do not skip lines between entries. The Amount Due field in the upper portion of the statement must be entered manually. This cell is then referenced in the stub portion.
482 Stock Balance Record
483 The balance-on-hand calculation assumes that issuing an item is the same as using (or selling) it. The Used Month to Date column is included for comparisons. Document the source of information in the reference column. The calculations depend on whether you enter a date. If you skip a date, your results may be incorrect, so make sure you enter dates in every row.
484 Summary of Key Accounts
485 Activity Ratios
486 Annualized NPV
487 Be sure to enter the initial investment as a negative number and do the same with any annual cash outflow.
488 Bill of Lading
489 Make duplicate (or triplicate) copies with one to accompany the shipment and one to be retained by the shipper. A third copy may be required by the carrier as proof of delivery. You may prepare this form electronically or print it and fill it out by hand.
490 Cash Receipt
491 Enter a number in the first receipt, and formulas will calculate other receipts and number them consecutively.
492 Daily Production Report
493 There are no time calculations.
494 Debt Ratios
495 Employee Time Sheet
496 Note that the worksheet does not calculate the number of hours worked, in order to give you flexibility in calculating overtime hours. Enter the hours as values, as they are totaled at the bottom of the worksheet.
497 Financial Comparison
498 Totals, shareholders' equity, and financial ratios are calculated automatically after all your financial data is entered.
499 Five Year Projections
500 Enter the beginning year of the analysis in the cell provided. The other year headings will be calculated automatically. Please note that the entry cells for "Cash outflow" require negative numbers.
501 Income Planning Worksheet
502 Use your Federal Income Tax Form 1040 as the source for most of the input values.
503 Income Statement
504 Enter data for the current month and the year to date. Each line item is automatically calculated as a percentage of net sales.
505 Liquidity Analysis
506 Material Requisition
507 The purchasing department places an order and fills in the part designed to record the actual costs and various other significant purchasing details. In effect, this form is the beginning of the purchasing cycle. The form can be filled out manually or electronically. The only calculations in the worksheet are in the extended price column.
508 Payback Period
509 Be sure to enter the initial investment as a negative cash flow. The payback period calculation does not utilize the time value of money and therefore assumes that a present-day dollar is equal to a future dollar. The payback period calculation should be used in conjunction with time value of money calculations such as Net Present Value and Internal Rate of Return.
510 Petty Cash Report
511 Begin by entering the department, manager, and starting balance. Then enter the transactions as they occur, disbursements as positive numbers, deposits as negative. Before printing the final report, enter the closing date in the space at the top of the form.
512 Present Value Mixed Stream
513 A mixed stream of cash flows shows no particular pattern. You need to enter a period discount rate (%) for each stream of cash flows. The periodic discount rate is similar to an interest rate in that it represents an annual rate.
514 Production Reject Report
515 You may want to add a column for the production line on which the rejects occur in the event that you have more than one production line. Similarly, you may want to use separate worksheets for different products. This form is designed to be printed and filled out by hand, though it can be filled out electronically instead.
516 Profitability Ratios
517 Pro-Forma Balance Sheet
518 The first year date is entered manually, but subsequent year headings are calculated. The Retained Earnings figure for each year is calculated, to insure that Assets equal Liabilities plus Equity.
519 Pro-Forma Income Statement
520 Enter the starting year heading manually; the subsequent year headings are calculated automatically.
521 Project Cost Summary
522 The worksheet calls for calculating a set of financial evaluations that are not included in the file, but that you can find in most financial management texts. The projected numbers are included so that you can compare the estimates with actuals; either set of projected or actual numbers can be entered without the other numbers. You may enter data on the worksheet itself. The various analyses are intended to be entered as values.
523 Quarterly Cash Flow
524 Enter estimated and actual financial data in the designated columns for each month in the projection. The variance for each category is calculated automatically.
525 Quotation Evaluation
526 Enter data electronically, or print a blank form and fill it out by hand.
527 Receipt for Goods
528 Any problems with or damage to the shipment should be recorded, so that adjustments or credits can be documented when the invoice arrives. This worksheet is designed to be printed and filled in by hand.
529 Receiving Report
530 You may fill in heading data such as the name and address of the vendor, your PO number, and so forth, at the time a PO is cut and file a copy of the partially completed form in a tickler file for transmission to the receiving department when the shipment is due.
531 Shipping Order
532 Customers should receive a copy of the form since it informs them of important information, such as their order numbers.
533 Telephone Sales Order
534 When you have completed this form, send a copy to the customer for confirmation. Click the button in the upper right portion of your screen to enter sales tax.
535 Vendor Cost Analysis
536 The order is allocated automatically among vendors based on the relationship between the vendor's price and the average price quoted by all vendors. The allocation gives each bidder an order of equal dollar volume. So that you can fine-tune the allocation to your needs, it is possible to override the allocation, permitting you to maintain even-lot orders, for example. Simply enter your own figures in the first column of the allocation.
537 Vendor Master File
538 Use the Remarks column to record important points that will enable you to evaluate a vendor. There are no calculations.
539 Weekly Cash Flow
540 Enter the date for the first week in column C. The dates for the remaining five weeks are automatically displayed.
541 Click on a cell, then choose Change Page Setup.
542 Click on a cell, then choose Change View.
543 Click on a cell, then choose Zoom.
544 Click on a cell or range of cells, then choose Format the Table Area.
545 Click on a cell or range of cells, then choose Format Title Area.
546 Click on a cell, then choose Insert Text Box.
547 Click on a cell, then choose Insert Current Date.
548 Click on a cell or range of cells, then choose Insert Text Box.
549 Click on a cell or range of cells, then choose Insert Signature Line.
550 Click on a cell or range of cells, then choose Align Data.
551 Click on a cell, then choose Create Headers/Footers.
552 Click on a cell, then choose Create Text in a Box.
553 Click on a cell, then choose Create TextArt.
554 Click on a cell, then choose Create a Comment.
555 Click on a cell, then choose QuickCorrect On/Off.
556 Click on a cell or range of cells, then choose Change Number Format.
557 Click on a cell, then choose Insert Current Date.
558 Click on a cell or range of cells, then choose Check Spelling.
559 Click on a cell, then choose Save Notebook.
560 Click on a cell, then choose Print.
561 Click on a cell, then choose Publish to Barista.
562 Click on a cell or range of cells, then choose Clear Values.
563 Click on a cell or range of cells, then choose Sort.
564 Click on a cell, then choose Turn QuickFilter On/Off.
565 Click on a cell, then choose Find and Replace.
566 Click on a cell, then choose Create a Budget.
567 Click on a cell, then choose Analyze Data.
568 Click on a cell, then choose Build Formulas.
569 Click on a cell or a range of cells, then choose Change Font Properties.
570 Click on a cell or a range of cells, then choose Format Numbers.
571 Click on a cell or range of cells, then choose Center and Align.
572 Click on a cell or range of cells, then choose Add Background Color.
573 Click on a cell or range of cells, then choose Create Cell Lines.
574 Click on a cell or a range of cells, then choose Insert.
575 Click on a cell or a range of cells, then choose Delete.
576 Click on a cell or a range of cells, then choose Make Columns Fit.
577 Click on a cell or a range of cells, then choose Specify Column Width.
578 Click on a cell or a range of cells, then choose Specify Row Height.
579 Click on a cell, then choose Insert an Image.
580 Click on a cell, then choose Create Graphic Text.
581 Click on a cell, then choose Create Shapes/Lines.
582 Click on a cell or a range of cells, then choose Create Chart.
583 Click on a cell or a range of cells, then choose Create Map.
584 Click on a cell or a range of cells, then choose Create Slide Show.
585 Click on a cell or a range of cells, then choose Try Different Scenarios.
586 Click on a cell or a range of cells, then choose Do Math in Groups.
587 Click on a cell, then choose QuickSum.
588 Draft
589 Page
590 25%
591 50%
592 75%
593 100%
594 150%
595 200%
596 Turn QuickCorrect Off
597 Turn QuickCorrect On
598 From the Scrapbook
599 From File
600 Text Box
601 TextArt
602 Arrow
603 Line
604 Rectangle
605 Rounded Rectangle
606 Ellipse
607 Button
608 About Notebooks
609 Page Setup
610 Page View
611 Zoom
612 Format Area
613 Select Cells
614 Size and Move Text Boxes
615 Change the Text Box Look
616 Create a Text Box
617 Format Area
618 Select Cells
619 Size and Move Text Boxes
620 Change the Text Box Look
621 Create a Text Box
622 Typing in Cells
623 Basic Data Entry
624 Typing in Cells
625 Basic Data Entry
626 Fill In a Pattern
627 Comments
628 Fill In a Pattern
629 Number Format
630 About Dates and Time
631 Finish
632 Work with Data
633 QuickFilters
634 Select Cells
635 Easy Format
636 Change Cell Appearance
637 Resize Rows and Columns
638 Insert Notebook Sheets
639 Change Margins
640 Editing Graphics
641 Scrapbook
642 Shapes and Lines
643 Enter Formulas
644 Formula Basics
645 Selecting Cells
646 Move and Copy
647 Cell References
648 Enter Formulas
649 QuickSum
650 About Entering Formulas
651 Formula Basics
652 About the Formula Composer
653 Title
654 Signature
655 Date
656 Activity ratios help to measure a company's efficiency managing certain assets., such as inventory, accounts receivable, and long-term and total assets.
657 Change the size, color, and font face of your text
658 Set the color of the cell's background
659 Select which lines around the cell should show
661 Start
662 Whatever document you choose will open into a new document window
663 More Quick Math
664 2-Column Quick Math
665 Calculating in Cells
666 Creating Formulas
667 Quick Math
668 Blank Notebook
669 New Project/Existing Notebook
671 Enter a formula that performs an operation on each item in a column or row
672 Enter a formula that performs an operation between each item in two columns or rows
673 Learn how to type numbers in cells to perform quick calculations
674 Learn how to create formulas manually by typing in cells
675 Enter a formula that performs an operation on an entire column or row
