Financial Excel Templates

thanks a bunch!!!
i soo badly needed dis!!
we've been given a project on financial planning of a person.
n i'm completely lost :(

i hope i can make some sense outa d project wid d help of ur templates^_^
 
mail2payan said:
Hi,
am here again to present you all some excellent microsoft excel templates where you can work on different projects just by using this excel templates.
In the zip files, there are the following folders:
1. Company Finance
  • Balance Sheet.xlt
  • Break-Even Analysis.xlt
  • Business Acquisition.xlt
  • Business Indebtedness.xlt
  • Cash Budget.xlt
  • Cash Flow Sensitivity.xlt
  • Five Year Projections.xlt
  • Pro-Forma Balance Sheet.xlt
  • Pro-Forma Income Stmt.xlt
  • PV Mixed Stream.xlt
  • Start up Budget.xlt
  • Start up Capitalization.xlt
  • Statement of Cash Flows.xlt
  • Weekly Cash Flow.xlt

2. Personal Planning
  • Appointments.xlt
  • Cash Receipt.xlt
  • Collectibles Inventory.xlt
  • Daily Planner.xlt
  • Fitness Tracker.xlt
  • Grading Sheet.xlt
  • Important Documents.xlt
  • Monthly Calendar - Land.xlt
  • Monthly Calendar - Port.xlt
  • Petty Cash Report.xlt
  • Quarterly Planner.xlt
  • School Budget.xlt
  • Vacation Budget.xlt
  • Vacation Checklist.xlt
  • Vacation Planner.xlt
  • Wedding Budget.xlt
  • Yearly Calendar.xlt
  • Yearly Planner.xlt

3. Personal Finance
  • 401K Planner.xlt
  • 401K Reallocation.xlt
  • Balloon Payment Loan.xlt
  • Basic Bond Valuation.xlt
  • Buy vs Lease Car.xlt
  • Capital Gain and Loss.xlt
  • College Monthly Budget.xlt
  • Extra Payment Analyzer.xlt
  • Financial Calculator.xlt
  • Financial Condition.xlt
  • Future Value Annuity.xlt
  • FV of Retirement Plans.xlt
  • Holiday Budget.xlt
  • Investment Record.xlt
  • Loan Calculators.xlt
  • Payback Period.xlt
  • Portfolio Allocation.xlt
  • Present Value Annuity.xlt
  • Present Value Lump Sum.xlt
  • Retirement Budget.xlt
  • Retirement Income Tax.xlt
  • Retirement Plan Contrib.xlt
  • Retirement Plans.xlt
  • Statement of Net Worth.xlt
  • Wealth Accumulation.xlt
  • Year End Tax Plan.xlt

4. Real Estate
  • 7 Year Balloon Loan.xlt
  • Biweekly Mortgage.xlt
  • Closing Costs.xlt
  • Gain on Sale of a Home.xlt
  • Home Equity Comparison.xlt
  • Home Equity Qualify.xlt
  • Home Improvement Record.xlt
  • Home Mortgage Checklist.xlt
  • Home Rent or Buy.xlt
  • Household Inventory.xlt
  • Mortgage Amortization.xlt
  • Mortgage Qualifications.xlt
  • Mortgage Refinancing.xlt

5. Sales & Marketing (This is for Marketing Peoples, But it'll great help in Finance also)
  • 24 Month Sales Forecast.xlt
  • Direct Mktg Analysis.xlt
  • Moving Avg Forecast.xlt
  • Mthly Sales Projections.xlt
  • Mthly Sales Seasonality.xlt
  • Product Sales Goals.xlt
  • Qtrly Budget Analysis.xlt
  • Qtrly Marketing Budget.xlt
  • Quarterly Sales Record.xlt
  • Sales Channel Analysis.xlt
  • Store-to-Store Sales.xlt
  • Summary of Key Accounts.xlt
  • Telephone Sales Order.xlt

If you like my post, please do reply with comments, so that I can post more threads to help you peoples in finance. I have lots of tools, ebboks related to FINANCE.

Thank You,
Enjoy....:thumb:
Click to expand...

thank u.......Keep posting such good files.....................
 
Hi Daipan

It would be appreciated if you would email me your Excel Template as I cannot extract this as it tells me file corrupted. my email is [email protected].

I also have a problems below relating to using a Financial Calculator to calculate the value for 2 bonds below. I use an HP 10B calculator , but the procedure should be the same for a Sharp, Casio etc

There are 2 bonds in a portfolio. Each bond matures in 4 years, has a face value of $1000, and a yield to maturity of 9.6%.

One bond, Bond C, pays a coupon rate of 10%, the other bond, Bond Z, is a zero coupon bond.

Assuming that the yield to maturity of each bond remains at 9.6% over the next 4 years, what will be the price of each of the bonds at the following time periods? See table below

t Price of Bond C Price of bond Z
0
1
2
3
4




It would be appreciated if you would set out the exact steps as well as the solutions

Your assistance will be most appreciated

Regards

Howard
 
Dear It is gud to see that you uploaded these types of templates. But dere is one problem in downloading these templates. I f u hav any suggestion then plz reply

thnx
M K naved
 
You must log in or register to reply here.
Back
Top