New View to Finance with Excel

 
 
 
Sorry this product is no longer available.
Are you well aware of the Finance Principles but do not know how to implement them in Excel?
Are you not aware of Financial Principles but are good with Excel?
Ok... This is for you then…

 

Excel with Finace 

 The New View to Finance with Excel is new and unique book that comprehensively integrates Excel into the teaching and practice of finance. This book provides exceptional resources to the instructor and student, combining classroom-tested pedagogy with the full potential of Excel's powerful functions.

Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. The New View to Finance with Excel bridges this gap between theory and practice by providing a nuts-and-bolts guide to implement Finance Principles in Excel.

The New View to Finance with Excel will help allow you to become more proficient in building and applying financial models, enabling you to get better, more accurate results, fast.

Some Comments from the readers…

"You have transformed me, an IT person, into someone who now knows QUITE a bit about financial management, and who can now quote, debate and discuss with the best of them!”

--- Glen McCarthy, Washington, DC, USA

“An ebook that from every prospective an MBA should have, as it is very clear and gives a lot of resource listings and examples. Strongly recommended for anyone, who needs to deal with financial issues.”

--- Madis Muller, Franklin, MA USA   

 

After studying this eBook you should be able to…

  1. Explain the basic purpose of a spreadsheet program.
  2. Identify the various components of the Excel screen.
  3. Navigate the Excel worksheet (entering, and moving data within the Worksheet)
  4. Explain the purpose and usage of Excel’s built-in functions and macros)
  5. Create graphics and know how to print and save files in Excel.
  6. Explain the purpose and understand firm’s three basic financial  statements
  7. Construct each of these statements in Excel with data for any company.
  8. Link worksheets together so that formulas in one worksheet can reference data in another.
  9. Use Excel’s Outline tool to selectively display or hide parts of a financial statement.
  10. Explain the purpose of the cash budget and how it differs from an income statement.
  11. Calculate a firm’s expected total cash collections and disbursements for a particular month.
  12. Calculate a firm’s expected ending cash balance and short-term borrowing needs.
  13. Demonstrate how Excel can be used to determine optimal timing of cash expenditures.
  14. Use the Scenario Manager to evaluate different assumptions in a model.
  15. Use the various tools that Excel provides to find and fix errors in formulas.
  16. Describe what financial ratios are and who uses them.
  17. Define the five major categories of ratios (liquidity, efficiency, lever-age, coverage, and profitability).
  18. Calculate the common ratios for any firm by using income statement and balance sheet data.
  19. Use financial ratios to assess a firm’s past performance, identify its current problems, and suggest strategies for dealing with these problems.
  20. Calculate the economic profit of a firm.
  21. Explain how the percent of sales method is used to develop pro-format financial statements, and how to construct such statements in Excel.
  22. Use the TREND function for forecasting sales or any other trending variables.
  23. Perform a regression analysis with Excel’s built-in regression tools.
  24. Define the terms business risk and financial risk, and describe the origins of each of these risks.
  25. Use Excel to calculate the DOL, DFL, and DCL and explain the significance of each of these risk measures.
  26. Explain how the DOL, DFL, and DCL change as the firm’s sales level changes.
  27. Explain the concept of the time value of money.
  28. Calculate the present value and future value of a stream of cash flows using Excel.
  29. Explain the types of cash flows encountered in financial analysis, and how to adjust for each type in making time value calculations in Excel.
  30. Differentiate between the alternative compounding periods, and use
  31. Excel to compare present and future values under different compounding schemes.
  32. Identify the relevant cash flows in capital budgeting.
  33. Demonstrate the use of Excel in calculating the after-tax cash flows used as inputs to the various decision making techniques.
  34. Compare and contrast the six major capital budgeting decision techniques (payback period, discounted payback, NPV, PI, IRR, and MIRR).
  35. Explain scenario analysis, and show how it can be done in Excel.
  36. Use Excel’s Solver to determine the firm’s optimal capital budget under capital rationing.

And much more

 Below is the snapshot of broad topics covered…

  1. Spreadsheet Basics
  2.  The Basic Financial Statements
  3. The Cash Budget
  4.  Financial Statement Analysis Tools
  5. Financial Forecasting
  6. Break-Even  and Leverage Analysis
  7. The Time Value of Money
  8. Valuation and Rates of Return
  9. The Cost of Capital
  10. Capital Budgeting
  11. Risk, Capital Budgeting, and Diversification
  12. Excel Menu descriptions

Click the add to cart button below to get my exclusive, not available elsewhere eBook instantly. It is in .PDF format and will be available for download immediately after payment. That's right; even if it's 3am you'll get it!

Best of Success

Richard

 Billing by PayPal using Industry Standard SSL Protection