Tuesday, January 30, 2018

Valuation of a Firm

How much is that busy car wash business worth?  




How much should Len and Jen sell their bake shop for? 

This week, we will learn how to value a company using some of the formulas that we already discussed in class.

We will go through two examples of how to do this using an Excel workbook.

To access the spreadsheet, please click on this link.



Comparing company profit margins



Ever wonder just how profitable a company or industry can be?


To compare how efficient a company is at making money, we calculate the firm's profit margin, which is equal to the operating profit / total sales.



To access the spreadsheet exercise, please click on this link.

Monday, January 22, 2018

Week 2 PRMDAS, Excel --> NPV PV and IRR

This week, we will review PRMDAS, PV, NPV and IRR.

Here is the first Excel spreadsheet that you should download. 



In the second example, we will determine whether a business venture makes sense.
Please click on this link to access the Excel spreadsheet.







Tuesday, January 16, 2018

Welcome to WHAE Business Math!

Hi Students,

On our class blog you'll find important information related to the course.


Please click here for a downloadable copy of the course syllabus.

Please click here for a downloadable version of Week 1's Powerpoint presentation.

To access the first class assignment (Martha's Flower Shop cash flows), please click on this link.

If you have any further questions you can drop me a line at rwiegs@gmail.com

Hope you enjoy the course.

Richard Wiegand