Instruction
This week’s assignment has two parts. Part 1: This week’s module is about financial ratios and your assignment summarizes much of what you should have learned in the module. Do problem 4-6 (Ratio Analysis for A. Thiel Mfg.) on page 143 and 4-9 (Ratio Analysis for Pamplin, Inc.) on pages 144-145 of the text. Be sure to do both the calculations AND the comments. Confine both calculations and comments to the six ratios for which you are responsible. Those ratios are: • Current Ratio • Quick Ratio (also called Acid Test) • Inventory Turnover • Operating Profit Margin • Debt Ratio • Return on Equity Your calculations must be done in Excel and you must use Excel formulas to do your calculations. Spreadsheets is a prerequisite for this course so you should be able to do this. Use help screens if you have forgotten. I must see your work when you calculate each ratio and the Excel formulas are “your work”. Note that you will get full credit only if you use the functionality of Excel to the max: if you can use cell references, do that rather than reentering data; use Excel formulas rather than calculating longhand, etc. Part 2: At this point you should be well along with your weekly account monitoring in the stock market simulation project. As noted in the Course Info section, we need a screenshot from the market close as of Feb. 17. Copy/paste into Excel your screen shots for this week’s market close (this can be in a separate worksheet). Under your screen shot give some commentary as to why you chose your stocks, how the investments are performing.
TEXTBOOK: FOUNDATIONS OF FINANCE, 9th EDITION by Keown, Martin, Petty ISB: Hard copy 9780134083285 ebook 9780134084084