Posted: March 11th, 2015

Budget, Paste/Special/Values to put the numbers on the new sheet and Paste/Special/Format to reformat the worksheet.

Instructions
Part 1
Use this template to complete the text assignment for Chapter 7. On the Data P7-8 ply, you may want to
fill in the monthly expenses in Cells F34:I37. You may need some of the numbers later in the
budget process. REMEMBER TO INSERT YOUR HEADER IN EACH PLY.

REMEMBER

There should be no numbers (except financing section) and only formulae below this point (on the worksheet).

Once the Budget for the text question is complete,  either print the worksheet or select the whole worksheet (CrtlA), Copy, Click on the Orig

Budget, Paste/Special/Values to put the numbers on the new sheet and Paste/Special/Format to reformat the worksheet. This will be your text assignment.

Part 2

Because of an optimistic economic position, your boss has asked you to prepare a budget at 10% above the expected level of activity. As instructed on your Data ply,

change  Cell F21 to 110% to change to the base for the second Budget. Note many of the numbers should change on the worksheet. You will need to do some checking.

1. Redo the financing to reflect the changes  in the new sheet. Change as required the borrowing, repaying, and interest payment.

2. Does your financing activity still work according to the plan?
3. Were you able to repay the whole bank loan and keep the minimum required balance in the bank account?

4. Does the balance sheet still balance?

Once the second Budget for the Computer assignment is complete,  either print the worksheet or select the whole worksheet (CrtlA), Copy, Click on the Solution Increase

in sales ply in the worksheet.Paste/Special/Values to put the numbers into the new sheet and Paste/Special/Format to reformat the worksheet. This will be the numeric

part of your CA#3.

Part 3

You will be evaluated on your use of formula in your assignment. If you are printing your assignment, in the worksheet ply, with your original answer, hold Ctrl~

(beside the 1 on a normal keyboard). The formulae under the numbers in your budget will appear. Print this sheet( Do not worry that the type is very small.  If you are

submitting your assignment on line, submit the file with the 4 plies (Data, Worksheet, Original Solution, and Solution Increase in Sales through Moodle .

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat+1-631-333-0101EmailWhatsApp