100	Turn Highlight On/Off
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
676	Click on a cell, then try again.
677	Yes
678	No