Spreadsheet 1 Instructions

Spreadsheet 1 Instructions - ACIS 1504 Spreadsheet #1...

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

View Full Document Right Arrow Icon
ACIS 1504 – Spreadsheet #1 Homework Instructions Overview The purpose of this homework assignment is to demonstrate your mastery of spreadsheet design and development. In this assignment, you will create a budget for yourself for the current semester and post the file to the s1hw Courseware folder. You do not have to use real data, but make your numbers and categories realistic. Requirements Detailed instructions for completing this workbook are included on the following pages. If you need help with this assignment, please contact your instructor or one of the tutors at the Center for Academic Enrichment and Excellence. You may also use the Custom CD, the textbook, or Excel help. (See pages Office 14 and 15.) All page references in this document refer to Illustrated Series Microsoft Office Excel 2007. You must use Excel to complete this assignment. You may be able to complete the entire assignment in an older version of Excel. If you do not have access to Microsoft Excel, you can find the application and WebDrive installed on computers in Pamplin 2010 and other labs on campus. Save your work frequently. What is a Budget? A budget is a comprehensive financial plan. For this assignment, your budget will cover the time period of the five months this semester spans (Fall is August-December and Spring is January- May). You will be providing monthly figures, not daily, weekly or annual. You will be providing both revenue (money you receive) and expenses (money you spend). Revenue can be money you’ve earned or money that is given to you directly or indirectly. Expenses are all the things you spend your cash on and all the things you purchase on credit. If you make more money than you spend, you have income. If you spend more money than you make, you have a loss. We will be ignoring rules of accrual accounting since most students in the class are not familiar with these concepts. Our budget will be created in this assignment and enhanced in the next two spreadsheet assignments. We will use our imagination to pretend we created the budget at the beginning of the semester. In the first month, we don’t know all of our revenue and expense amounts for the entire semester, so most of our numbers will be predictions or forecasted amounts. Then we will pretend some time has passed and we will update our budget. As time passes, we can look back and see exactly how much money we actually earned and how much we really spent. Finally, we will pretend the entire semester is over and we will evaluate our financial plan to determine how
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/15/2011 for the course ACIS 1504 at Virginia Tech.

Page1 / 4

Spreadsheet 1 Instructions - ACIS 1504 Spreadsheet #1...

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

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