Formatting Tips

How Represent Financial Value

As you can see in Figures 2.3 to 2.7, certain formatting techniques aid in the construction of a worksheet. Take note of these uses of formatting these formatting tips are also covered in the appendix Bold headings to change text in a cell to a bold format, select the cell of interest, select the Home tab on the Excel ribbon, and choose the bold selection usually a bold uppercase B icon in the Font section of the ribbon. Center alignment to center text in a cell, select the cell of interest,...

Step 7b Disbursements For Capital Expenditures Budget

Capital Expenditure Budget Spreadsheet

The Disbursements for Capital Expenditures Budget reconciles the accrual values from Step 7A to cash figures. This schedule ties into the creation of the Cash Budget, which is covered later in this chapter. My financial model makes the assumption that Napavale disburses, or pays for, 100 percent of the current period's capital expenditures purchases. This assumption is highlighted in the Assumptions and Dashboard worksheet in Figure 6.7. Note that I am treating the disbursements for capital...

Info

Cost Goods Sold Budget

FIGURE 3.1 Cost of Goods Sold, Inventory, and Purchases Components of the Operating Budget in the Context of the Master Budget As Napavale sells a specific product a flat-screen computer monitor , I will be using a Cost-of-Goods-Sold Budget. If you are building a financial model for a service-oriented company, you may either identify and allocate the costs associated with service revenues to an account named cost of revenues or ignore this account altogether it is up to you. It is essential,...