Chapter_02 - Ross, Westerfield, and Jordan's Spreadsheet...

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

View Full Document Right Arrow Icon
by Brad Jordan and Joe Smolira Version 9.0 Chapter 2 In these spreadsheets, you will learn how to use The following conventions are used in these spr 1) Given data in blue 2) Calculations in red NOTE: Some functions used in these spreadsheets may the "Analysis ToolPak" or "Solver Add-In" be installed in To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analysis ToolPak" and "Solver Add-In," then click "OK." Ross, Westerfield, and Jordan's Spreadsheet Master Fundamentals of Corporate Finance, 9th edition Cell formatting Trace Dependents/Precedents VLOOKUP Referencing across worksheets
Background image of page 1

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

View Full DocumentRight Arrow Icon
e the following Excel functions: readsheets: y require that in Excel.
Background image of page 2
Chapter 2 - Section 1 The Balance Sheet Example 2.1: Building a Balance Sheet RWJ Excel Tip Given the following information, what does the balance sheet look like? What is share Current assets: $100 Net fixed assets: $500 Short-term debt: $70 Long-term debt: $200 RWJ Excel Tip Assets Liabilitie Current assets $100 Current liabilities Fixed assets 500 Long-term debt Shareholders' eq Total liabilities an Total assets $600 shareholders' e Spreadsheets are a very useful way to do financial calculations. Throughout these spreads the textbook. However, using Excel or any spreadsheet program is not a substitute for und definitely applies to spreadsheets. You should realize that you do not need to understand t would recommend that you first read the textbook to understand the concepts before you w the problems by hand or using a financial calculator. As with most calculations, there are o method of solving the problem presented, not necessarily the only way to solve the problem Throughout these spreadsheets, Excel tips will be highlighted in blue. The tips will range fr will use is building a basic balance sheet. Although we could build a balance sheet and en create a column of variables and then refer to these input cells in the balance sheet. We a these spreadsheets, if the number is blue , it is an input cell. If the number is red , the cell is In order to make a spreadsheet more presentable, cell formatting is important. To make th percentage, or other format, select the cells you want to format, right-click, and select the " font, text color, cell background color, and lots of other options.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Net working capital = Current assets - Current liabilities Net working capital = $30 Many of the examples in this chapter deal with the fictitious U.S. Corporation. The balance RWJ Excel Tip Assets 2008 2009 Current assets Cash $104 $160 Accounts receivable 455 688 Inventory 553 555 Total $1,112 $1,403 Fixed assets Net plant and equipment $1,644 $1,709 Total assets $2,756 $3,112 RWJ Excel Tip To calculate the shareholders' equity, realize that total liabilities and shareholders' eq shareholders' equity. Using these relationships, we can solve for shareholders' equity Note that we will enter the data for the balance sheet here, but reference the numbers acro balance sheet balances, we will have Excel do the balance sheet calculations for us anywa number is given in the textbook.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/16/2011 for the course FIN 521 taught by Professor Varney during the Spring '11 term at Andrew Jackson.

Page1 / 24

Chapter_02 - Ross, Westerfield, and Jordan's Spreadsheet...

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

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