Excel Word

1801 words 8 pages
Show More
-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
Shelly Cashman Excel 2010
-------------------------------------------------
Chapter 3: Lab 1
Six-Year Financial Projection
Skills

Save a workbook with a new name
Apply a theme to a worksheet
Select all cells in a worksheet
Apply bold
Enter text in cells
Change the font
Change font size
Create a formula using the NOW function
Apply the date number format
Modify column width
Modify row height
Fill a range of cells with a series
Center cell contents
Italicize text
Rotate text
Use the Format Painter
Add borders
Indent cell contents
Enter numbers with format …show more content…

Copy cell B6 to the range C6:G6.
In cell B8, enter the following formula: Year 1 Advertising (cell B8) = 500 + 8% * Year 1 Sales or =500 + 8% * B4. Copy cell B8 to the range C8:G8.
In row 9, enter the following data: Maintenance (row 9): Year 1 = 1,605,000; Year 2 = 4,378,000; Year 3 = 5,920,000; Year 4 = 5,050,000; Year 5 = 3,200,000; Year 6 = 4,250,000.
In cell B10, enter the following data: Year 1 Rent (cell B10) = 2,700,000
In cell C10, enter the following formula: Year 2 Rent (cell C10) = Year 1 Rent * (1+12%) or =B10 * (1+12%). Copy cell C10 to the range D10:G10.
In cell B11, enter the following formula: Year 1 Salaries (cell B11) = 17% * Year 1 Sales or =17% * B4. Copy cell B11 to the range C11:G11.
In cell B12, enter the following formula: Year 1 Shipping (cell B12) = 3.9% * Year 1 Sales or =3.9% * B4. Copy cell B12 to the range C12:G12.
In cell B13, enter the following formula: Year 1 Supplies (cell B13) = 1.3% * Year 1 Sales or =1.3%*B4. Copy cell B13 to the range C13:G13.
In cell B14, enter the following data: Year 1 Web Services (cell B14) = 250,000.
In cell C14, enter the following formula: Year 2 Web Services (cell C14) = Year 1 Web Services * (1+15%) or =B14*(1+15%). Copy cell C14 to the range D14:G14.
In cell B15, enter the following formula: Year 1 Total Expenses (cell B15) = SUM(B8:B14). Copy cell B15 to the range C15:G15.
In cell B17, enter the following formula: Year 1

Related

  • Final Project Auto parts word and excel
    2378 words | 10 pages

    Study CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any assistance I received in its preparation is fully acknowledged and disclosed in the paper. I have also cited any sources from which I used data, ideas or words, either quoted directly or paraphrased. I also certify that this….

    Show More
  • Course Project
    2311 words | 10 pages

    Proposal Template.docx so your professor is reminded which business you’re doing. | Task 5: | Save the draft of the Budget Proposal Word document and Budget Proposal Excel calculation and submit it to the Week 2 Project Dropbox. | L. Grading Criteria | Description | Suggested Points | There is a 5 year sales forecast in the Word document Section 2.1 and the Excel spreadsheet (in sales dollars). | 2 | The 5-year forecast appears to be based on research, reasonable assumptions, and methodologies….

    Show More
  • Report on Job Analysis
    3572 words | 15 pages

    | REPORT: JOB ANALYSIS | | CIPD DIPLOMA IN HR PRACTICECIPD NO 2317474X3CJA CONTRIBUTING TO THE PROCESS OF JOB ANALYSIS WORD COUNT 1529MARIA DUYA16TH OCTOBER 2012 | CONTENTS PAGE Principles and Purpose of Job Analysis 2 Compare and Contrast 3 methods of Job Analysis 2 - 3 Contribute to the Process of Job Analysis 4-6 References 7 Appendix 1 Estates and Facilities Organisation Structure 8 Appendix 2 Business Service Organisation Structure 9 Appendix….

    Show More
  • Ged 155 English Exam Unit 3
    978 words | 4 pages

    20. Use ________ to set off the word sic, which indicates “as written” in a quotation. a. parentheses b. brackets c. commas d. apostrophes 21. Identify the sentence that is correctly punctuated. a. When the police recover the lost merchandise—a diamond bracelet, they will….

    Show More
  • Apple Innovation Strategy
    2410 words | 10 pages

    A School of Business STR/581 Strategic Planning & Implementation Whenever there is any question including about what assignments are due, this syllabus is considered the ruling document. Point Values for Course Assignments ASSIGNMENTS | Points | Individual (90%) | | Participation (All Six Weeks) 180 Pts….

    Show More
  • Comparative Analysis of Kohl and J.Cpenny
    912 words | 4 pages

    then scroll down and select the 10k dated 3/18/2011 and choose to download in Word or PDF format. http://www.kohlscorporation.com/InvestorRelations/sec-filings.htm Below is the link for the financial statements for J.C. Penney Corporation for the 2010 fiscal year ending January 29, 2011. Under the term Groupings Filter, change the term All Forms….

    Show More
  • St Dismas
    1286 words | 6 pages

    Week 6 Discussion For the Week 6 Discussion you will create a Gantt chart for one element of the St. Dismas case study project. Using a project management tool like MS Project is typically the easiest and fastest way to do this. However, it is not the only way. You can use MS Office products as well to create the Gantt Chart. Students often ask about the use of project management software applications in this course. In the past we required the use of MS Project for this course but removed….

    Show More
  • Flirting with Risk
    1240 words | 5 pages

    is 0,0545 and the standard deviation is 0,0132. The risk level is less than the risk level of investing in only one of the two stocks ( See the excel file for standard deviations of non-diversified portfolio). The expected return is realistic since there is not much difference when compared with non-diversified investments’ expected returns. In other words the expected results are not very high which makes them realistic. Table 4 9. What would happen if Mary were to put 70% of her portfolio in….

    Show More
  • Case Study
    1365 words | 6 pages

    Assignment 2 Weight: 35% Total Marks: 100 Due time and date: 23.59AEST, Sunday, 31 July, 2016 Submission instructions: 1. Maximum word length: 3000 words (excluding references, tables and figures). 2. Submit a soft copy in Word format via Turnitin (with an assignment cover sheet). 3. Assignments submitted by other means (e.g. email) or forms (scanned copy, Excel document) will attract no marks. Late submissions: The mark for an assessment item submitted after the designated time on the due….

    Show More
  • 1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey
    936 words | 4 pages

    1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempseyvvv1. Calculate the revised product costs for the four pens, based on the activity information collected by Dempsey1. Calculate the revised product costs for the four….

    Show More

Popular Essays