# Financial Formula Calculations

## Excel Financial Formula Calculations for Financial Analysis

 Submit an Excel Solution Submit Solution [Guide]

 Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

 Financial Formula Calculations Rate this solution: (3/5 from 2 votes) Buy Now
 The Financial Formula Calculation Templates for Excel give the resources of an interactive and portable MBA reference guide. Armed with these templates, the user is able to solve the most common financial problems that you encounter on a daily basis. In one integrated Excel workbook, the user can easily select over 40 worksheets from a main menu to solve a wide range of financial calculations. Categories of Excel templates for financial formula calculations included are: Investment Valuation Financial Statements Ratios Time Value of Money Rates of Return Capital Budgeting Loans and Leasing Features of the Financial Formula Calculation Templates for Excel include: Determine the value of a bond; determine the annual yield for a bond if held to maturity Establish book and liquidity values. Quickly determine liquidity and activity ratios. Calculate debt and profitability ratios. Determine the present value of a single amount, a mixed stream of cash flows or of an annuity. Understand the future value of a single amount or an annuity. Calculate the net present value of an investment with up to 15 years of cash flow; calculate the annualized net present value. Compute the annual rate of return needed to meet a financial goal. Determine the real rate of return and the after tax return; ascertain taxable equivalent rate. Calculate a monthly lease payment for a car. Determine loan pay-off amount. Assess a consolidation loan to pay off debt. Use the refinancing calculator to see if refinancing makes sense. Compute monthly payments and final payment for balloon mortgage . Calculate a loan; calculate a biweekly mortgage; determine housing affordability. Understand your personal safety debt ratio. A trial download is also available on the next page.

(Pricing is available on the next page)

 Related Excel Solutions: Charting Courses (Training and Tutorials) | Financial Analysis Templates (Financial Analysis) | Financial Functions (Financial Analysis) | Financial Calculations (Financial Analysis) | Financial Modeling Add-ins (Financial Analysis) | Financial Modeling Course (Training and Tutorials) | Financial Ratio Templates (Financial Accounting) | Financial Management Modeling (Training and Tutorials)

 Share your thoughts with other users: Create your own review

 Download Financial Formula Calculations Reference For iTunes & iOS Device

 Popular Searches 1. Automate cost allocation 2. Financial analysis templates 3. Allocate 4. Excel 5. Capture ratio
 Add Economic Data to Excel Reports and Dashboards See How Here