Question

Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first day.

Step by Step instructions on completing PR1-5B.

**BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITE
ALL BALANCE FORMULAS.**

To do so do the following in order.

Click on Cell D39. In D39 you will write a formula to add rows D37 and D38. To do so do the following:

a) Start in Cell D39 and press = sign

b) Highlight cell D37 by using your mouse to click on it or use the arrow keys to move to that cell. When you do this you should see in D39 =D37

c) Now press the + sign then click on D38 or move with the arrows to cell D38. At this time, you should now see in cell D39 the formula =D37+D38

d) Now press the enter key.

e) Now you should see an amount like 60,000 with a red star. DO NOT worry about that red star right now.

f) To verify you have written the formula correct press the F2 key. When you do it should display the formula =D37+D38. Press the enter key to return to display the amount. Note: when you do this the cells D37 and D38 are highlighted in different colors that match the colors of the font type for each cell.

g) Now you are ready to copy and paste this formula down column D to the BALANCE rows which are the odd numbered rows, in other words the formula goes to EVERY OTHER ROW not to all rows.

h) To copy the formula to memory, hold down the control key and press the C key and then release the keys. You should now see a flashing black box around D39. This indicates to you that the cell D39 is in memory and can now be pasted into the other odd number cells in column D.

i) Now arrow down two rows with the down arrow key. You should see the green box around D41 at this point.

j) Now paste by holding down the control key and press the letter V as this will then paste the formula into cell D41.

k) Repeat this process by arrowing down twice and then pressing control and V, release, then arrow down twice more, press control and V, release, arrow down etc until you have pasted the formula to every other row in column D. Make sure those rows are only the BALANCE rows and are the odd numbered cells.

l) When you finish doing this you should see an amount like 60,000 with a red star in all the odd numbers rows in column D.

m) You now need to verify that you did this correct. To do so hold down the control key and press the ~ symbol then release all keys. The ~ key is on the top row to the left of the number 1 key. At this point you should see nothing but formulas similar to the formula in D39 EXCEPT the row numbers should have changed. For example, in D59 you should see the formula = D57+D58 where as in D45 you should see =D43+D44. Then to get back to the amount display press down and hold the control key and press the ~ key.

n) Now you can copy the entire column D “GRAY BOXES with those formulas from column D to all the other columns. To do so first highlight the entire gray boxes in row D from D38 to D59. Use your mouse to highlight OR click on cell D38, hold down the shift key, use the down arrow to highlight all the way down from D38 to D59.

o) Once highlighted you will copy this column by pressing control and the letter C. You should see the flashing border box all around D38 to D59 and only those cells. Make sure you do not have any blue cells highlighted, just gray cell.

p) Now click on G38 or use the right arrow key to move to G38 which now has the green solid box outlined around G38.

q) Now press the control key and letter V at the same time to paste the formulas. When you do you should now see an amount like 80,000 on the balance rows in Column G.

r) Repeat the above step to columns J, M, P, S, V, Y, AB, AE, AH, HK, AN, AN and AT. DO NOT STOP before you get to column AT. If you lose the flashing box around column D, just highlight again and copy using control and the letter C.. In several columns you will see no amounts but rather a – instead. This simply means the balance is 0 at this time.

s) Now verify that you did a great job copying and pasting the formulas by again holding down the control key and press the symbol ~ to reveal all the formulas. Press them again, and the display toggles back to the amounts and dashes.

This copy and pasting of the formulas will save you hours of times writing them over and over.

This is the end to the Excel Practice Exercise to get familiar with Excel. SAVE this work, you will need to use it in Chapter 1 homework.

Answer #1

60000 | 60000 | 60000 | ||||

=D37+D38 | =G37+G38 | =J37+J38 | ||||

=D39+D40 | =G39+G40 | =J39+J40 | ||||

=D41+D42 | =G41+G42 | =J41+J42 | ||||

=D43+D44 | =G43+G44 | =J43+J44 | ||||

=D45+D46 | =G45+G46 | =J45+J46 | ||||

=D47+D48 | =G47+G48 | =J47+J48 | ||||

=D49+D50 | =G49+G50 | =J49+J50 | ||||

=D51+D52 | =G51+G52 | =J51+J52 | ||||

=D53+D54 | =G53+G54 | =J53+J54 | ||||

=D55+D56 | =G55+G56 | =J55+J56 | ||||

=D57+D58 | =G57+G58 | =J57+J58 | ||||

Use a spreadsheet program – preferably Microsoft Excel, but you
may use any program you like – to illustrate diagrammatically your
answers to the preceding question.
(You should produce a graph that
features (a) an average total cost (ATC) curve; (b) a marginal cost
(MC) curve; and (c) a line representing the hypothetical price of
$9 per ride. The graph should be labeled appropriately, have a
reasonable scale on the vertical (cost) axis and horizontal
(quantity) axis. When you have...

Your factory has been offered a contract to produce a part for a
new printer. The contract would be for three years and your cash
flows from the contract would be $5 million per year. Your up-front
setup costs to be ready to produce the part would be $8 million.
Your cost of capital for this contract is 8%.
Complete the steps below using cell references to given data or
previous calculations. In some cases, a simple cell reference is...

In this assignment you will analyze the performance of actual
company divisions. FASB ASC 280 (formerly SFAS 131) requires
publicly traded companies to disclose segment information in the
notes to the financial statements. You will use Excel to create
visually appealing data tables and bar charts to analyze
division performance, and then comment on the results.
Due Date: Tuesday, May 1, 2018. Submit as an
attachment in Blackboard in the Module 24 Assignment.
SECTION I
The link is to...

You have just sold your house for $1,000,000 in cash. Your mortgage
was originally a 30-year mortgage with monthly payments and an
initial balance of $800,000. The mortgage is currently exactly 18½
years old, and you have just made a payment. If the interest rate
on the mortgage is 5.25% (APR), how much cash will you have from
the sale once you pay off the mortgage?
Complete the steps below using cell references to given data or
previous calculations. In...

Chapter 13: Applying Excel: Excel Worksheet (Part 1 of 2)
Download the Applying Excel form and enter formulas in
all cells that contain question marks.
For example, in cell C22 enter the formula "= B10".
Note: The present value factors could be computed using the
built-in Excel function PV, but we recommend using the formulas in
Appendix 13B.
Verify that your worksheet matches the example in the text.
Check your worksheet by changing the discount rate to 10%. The
net...

Amortization Schedule Project
Program an Excel Spreadsheet to complete a Fixed Payment Loan
Amortization Schedule based on the 5 inputs (see 1a below). This
spreadsheet should work for any scenario chosen using the 5 inputs
below that does not exceed 360 periods. You may start with any 5
inputs as these will be changed multiple times during grading. All
cells with number format should have no decimal places. All cells
with accounting format should have 2 decimal places. All cells...

Professor Wendy Smith has been offered the following deal: A law
firm would like to retain her for an up-front payment of $50,000.
In return, for the next year the firm would have access to eight
hours of her time every month. Smith’s rate is $550 per hour and
her opportunity cost of capital is 15% per year. What does the IRR
rule advise regarding this opportunity? What about the NPV
rule?
Complete the steps below using cell references to...

Problem #1 Confidence Interval for Means using the t and
z Distribution. Psychologists studied
the percent tip at a restaurant when a message indicating that the
next day’s weather would be nice was written on the bill. Here are
tips from a random sample of patrons who received such a bill,
measured in percent of the total bill:
20.8 18.7
19.9 20.6
21.9 23.4
22.8 24.9
22.2 20.3
24.9 22.3
27.0 20.4
22.2 24.0
21.1 22.1
22.0 22.7
Open an...

Excel Lab 2: Regression and Goal Seek
In this lab, you will use Excel to determine the equation of the
model which best fits a set of ordered pairs
obtained from data sets. You will enter data, graph the data, find
the equation for the regression model,
and then use that equation to make predictions for the dependent
variable. You will use the goal seek to make
predictions for the independent variable. Then you will consider
how accurate your predictions...

You take out a 25-year mortgage for $300,000 to buy a new house.
What will your monthly payments be if the interest rate on your
mortgage is 8 percent? Now, calculate the portion of the 48th
monthly payment that goes toward interest and principal.
Complete the steps below using cell references to given data or
previous calculations. In some cases, a simple cell reference is
all you need. To copy/paste a formula across a row or down a
column, an...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 4 minutes ago

asked 8 minutes ago

asked 12 minutes ago

asked 13 minutes ago

asked 39 minutes ago

asked 40 minutes ago

asked 48 minutes ago

asked 55 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago