Lab Assignments - Lab Assignments Lab 1 Pro Forma...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Lab Assignments Lab 1 Pro Forma Proforma.a.xls (18.5 Kb) Prepare a five-year pro-forma income statement for a new microcomputer store that you plan to open in January of next year. The title of the report should show your name and the name of your computer store centered above the report. You will find a starting file above. The Income statement should show five-year projections for Sales, Cost of Goods Sold, Gross Profit, Overhead, and Net Profit. Sales and Cost of goods sold will be projected to increase by a combination of a projected inflation rate and a projected growth rate. Overhead will be projected to increase by a fixed amount each year. Initial values are: Sales $135,000 Growth Rate .07 Cost of Goods 88,000 Inflation Rate .03 Overhead 30,000 Overhead Increase $1,000 Set up the spread sheet so that all initial values and growth factors are in a separate part of the spread sheet labeled Assumptions. The area containing the actual 5 year projection should show NO VALUES AT ALL , only formulas. Use these formulae for the projected amounts: Sales = prev.year.sales * (1 + growth.rate + inflation.rate) COGS = prev.year.cogs * (1 + growth.reate + inflation.rate)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Overhead = prev.year.ohead + OH.increase The cell references to growth.rate. inflation.rate., and OH.increase must be fixed Format all dollar amounts to show proper punctuation. Format percentages appropriately. Set column widths to have a readable and un-crowded arrangement. Lab 2 - Buyer's Guide
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/22/2010 for the course BUS 255 taught by Professor Mcgee during the Spring '10 term at Aarhus Universitet.

Page1 / 6

Lab Assignments - Lab Assignments Lab 1 Pro Forma...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online