Technology Financial Projection Assumptions

Problem: Your supervisor in the finance department at August Online Technology has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses, Operating Income, Income Taxes, and Net Income for the next eight years based on the assumptions in the next table. August Online Technology Financial Projection Assumptions Units Sold in Prior Year 235,411 Unit Cost $150.00 Annual Sales Growth 3.25% Annual Price Increase 3.00% Margin 29.90% Perform the Following tasks: Instructions Part 1: Open Excel, open a blank workbook, and then create the worksheet. Apply the Parallax theme to the worksheet. Enter the worksheet title August Online Technology in cell A1 and the subtitle Eight-Year Financial Projection for Product X in cell A2. Format the worksheet title in cell A1 to 26-point and the worksheet subtitle in cell A2 to 16-point. Enter the system date in cell I2 using the NOW function. Format the date to the 14-Mar-12 style. Change the following column widths: A=24.00 characters; B through I = 14.00 characters. Change the heights of rows 7,15, 17, 19, and 22 to 18.00 points. Enter the eight-column title Year 1 through Year 8 in the range: B3:I3 by entering Year 1 in cell B3 and then dragging cell B3’s fill handle through the range C3:I3. Format cell B3 as follows: Increase the font size to 12. Center and italicize it. Angle its contents 45 degrees. Use the Format Painter button to copy the format assigned to cell B3 to the range C3:I3. Enter the row titles as shown in Figure 3-85, in the range A4:A19. Change the font size in cells A7, A15, A17, and A19 to 14-point. Add thick bottom borders to the ranges A3:I3 and A5:I15. Use the Increase Indent button (Home Tab|Alignment group) to increase the indent of the row titles in cell A5, the range A8:A14, and cell A18. Enter the table title Assumptions in cell A22. Enter the assumption in Table 3-9 in the range A23:B27. Use format symbols when entering the numbers. Change the font size of the table title in cell A22 to 14-point and underline it. Select the range B4:I19 and then click the Number format Dialog Box Launcher (Home Tab | Number group) to display the Format Cells dialog box. Use the Number category (Format Cells dialog box) to assign the appropriate style that displays numbers with two decimal places and negative numbers in black font and enclosed in parentheses to the range B4:I19. Complete the following entries: Year 1 Sales (cell B4) = Unit sold in Prior Year * (Unit Cost/ (1-Margin)) Year 2 Sales (Cell C4) = Year 1 Sales * (1+ Annual Sales Growth) * (1+Annual Price Increase). Copy cell C4 to range D4:I4. Use Absolute Value in cell C4.

So much stress and so little time? Take care of yourself: let us help you with your task on
Technology Financial Projection Assumptions
Get a 20% Discount on this Paper
Order Essay
My Paper Support
Save More. Score Better
Pages (550 words)
Approximate price: -

Why Hire a Professional Essay Writer from MyPaper Support

Quality Urgent Essays

MyPaper Support online platform provides the best essay writing service ever received elsewhere, thanks to our professional essay writers. Experience gained in the 10+ years of being in the assignment writing industry is also an added advantage.

Professional and Experienced Academic Writers

A lot is done to maintain us as the best essay writing service provider. Besides owning a degree from a recognized university, a writer must pass the rigorous tests we take them through before they are considered eligible to offer urgent essay help on our website.

Affordable Urgent Assignment Help

Who said a reliable website should not be cheap also? While it is human nature to associate prices with quality, that does not always work. At mypapersuppport.com, we guarantee you cheap and urgent essay help without compromising the quality.

24/7 Available Urgent Essay Writing Service

Whether it is a ‘write my essay for me cheap’ or ‘edit my essay’ order you want to request, always feel free to reach us at any time of the day. Our experts work in shifts to ensure that you access urgent essay writing services at any time of the day.

Plagiarism Free Essays Online

The punitive measures that come with plagiarized content are so harsh, and we understand that. We consequently ensure to write each client’s papers from scratch no matter how urgent the essay is. To acknowledge borrowed content, our quick writer references and cites the work.

Wow Customer Support 24/7

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

So much stress and so little time? Take care of yourself: let us help you with your tasks. We offer all kinds of writing services.

Essays

Custom Essay Writing Services

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission and Business Papers

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Editing

Editing and Proofreading

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Coursework

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.