Spreadsheet In-Class Lab Exercise
Your Dear Uncle Schlocko has offered to advance you $5,000 to start your own home office.
All he asks is that you name the type of business (see below) and that you show how
you plan to expend the money. (You must use it all in the first three months of operation.)
Fill in here…  Your Name…        
                         Type of Business…        
Allocate the dollars below and fill in formulas to compute totals and percentages.
(Amounts indicated are suggested amounts - your expenditures may vary from these amounts.)
Startup        
Costs Jan Feb March Totals
Furniture  
Desk ($175)  
Chair ($90)  
Lamp ($30)  
File Cabinet ($120)  
Wiring ($10)  
 
Supplies  
Wastebasket ($6)  
In/Out Baskets ($4)  
Blotter ($20)  
File Folders ($8)  
Paper (ream, $3)  
Envelopes (50, $1.70)  
Tape (roll, $1)  
Stapler ($4)  
Fasteners ($3)  
Pens ($4)  
 
Other  
Rent ($600/mo)  
Phone ($150/mo)  
Electricity ($80/mo)  
Computer ($45/mo)  
Internet ($20/mo)  
Advertising ($100/mo)  
 
Total          
Percent