Financial Excel Templates

[reetikasharma_peacock]

hi buddy! i saw these templates and they are worth it. they are really good....... thank u so much :-)

[Archie]

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^_^

[rahul.khanna514]

Thankyou very much.... great work keep it up....

[kalpeshagrawal3]

Originally Posted by mail2payan

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....

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

[arv2006ind@yahoo.com]

Hey... that was very nice buddy.... if u can mail me on the financial planning templates than that will be a great help...

[nchadha]

HI thanks this looks list a very useful post

[yuvankarthik]

hey man... gud work... keep on uploadin ebooks related 2 fin.
thanx in advance..
regards,
yuvankarthik

[keyur7100]

realy it is very uesfull....... thank you daipayan

[priya.sweet123]

Thanks a lot...
Nice stuff
Very useful

[flupsie]

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 .

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