Over the years, I’ve been posting about hundreds of different things that can be done in excel. It’s incredibly powerful but also very complex. Just think about the human brain and how use only 1% or 2% of our capability. Excel is similar for 99% of users. I have been fortunate to spend a lot of time using it both for work, for fun and also for this blog. I’ve written about functions, macros and a lot more. I even have an ebook that covers tons of material with spreadsheet examples which I highly recommend.
If You Need Help With Your Spreadsheet Now
I know that for many of you, that is helpful but not enough. Why? You have a deadline, you have no more patience or time left, etc. I get it, believe me. Many of you send me your spreadsheets which I can often help with.
Do You Need A Quick Answer?
The thing is that I unfortunately cannot help every one with their spreadsheets. I wish I could, but it’s physically impossible. If you would like help and it’s not urgent, simply email me here:
A Paid Option
I decided to make another option available for those who need a quick answer and some help. I do have to charge for such a service though as you can hopefully understand. So here is how it works:
Step #1-You send me an email with:
-your current spreadsheet (even if it’s not completed)
-an explanation of your issue
-a phone number if you’d like me to call for more answers.. Email usually works fine but just in case
Step #2-You send me $39
This payment will give you the following:
-an answer within 24 hours, usually less. (I will either give you what you’re looking for or fix your spreadsheet). If the work required is more extensive, I will give you an estimate of how much I’d have to charge you. From experience, 95% of the emails that I get do not require more.
-if I cannot fix the issue or you don’t agree to my estimate, I will be more than happy to send you back your money.
You can pay by clicking here:
No Solution? Nothing To Pay, Guaranteed
I wish I didn’t have to charge money upfront but then I’d have to look at dozens of spreadsheets. At least, this way I’m able to know who is serious about needing help and get on those as quicky as possible.
Jim Stevenson
Buy lists or let us mail for you. Start acquiring new business from US dentists, doctors and businesses this week. Prices are reasonable. Email me for details: businessmaster2012@gmx.com
Chris
Hi
Bought yr ebook which is helpful but if i download any of the examples they seem to have the data but not the formulae / macros
Michael
I have had trouble with PayPal in the past and it took 6 mo to a year to get corrected and discontinue my PayPal account. Is there another option to get your ebook?
Hopefully there is a solution.
Thanks,
Mike
annaka
The company can raise 800 million to finance future projects
Debt 250 million at 6%
550 million at 8%
Equity
Tax rate 30 %
Cost of Project 1 – 230 millions
Per Million NI Depreciation Current Assets Current Liabilities Long term Liabilities
Year 1 – 3 1 2 -3 2
Year2 150 3 -1 2 -2
Year 3 75 1 -1 2 3
Year 4 40 0.5 2 2 1
Year 5 5 1 0 0 1
Cost of Project 2- 500 millions
Per Million NI Depreciation Current Assets Current Liabilities Long term Liabilities
Year 1 -3 1 2 3 2
Year2 250 1 -3 -2 -2
Year 3 250 1 -3 2 3
Year 4 40 0.5 2 2 0
Year 5 5 1 0 0 1
Cost of Project 3- 300 millions
Per Million NI Depreciation Current Assets Current Liabilities Long term Liabilities
Year 1 5 1 2 -3 2
Year2 150 1 3 -2 -2
Year 3 200 1 3 2 3
Year 4 40 0.5 2 2 0
Year 5 5 1 0 0 1
Simulation table
8% 9% 10% 11% 12% 13%
NPV project 1 25 5 -2 -8 -10 -20
NPV project 2 60 50 30 3 -2 -3
NPV project 3 20 15 5 -1 -3 -4
1- Kindly evaluate the three projects based on the NPV analysis, Discounted Payback Period and IRR analysis? Which project is the best?
2- If the WACC is now 15% which project would you accept based upon NPV and IRR?
Please help me !
Md. Shohel Rana
Can anybody help me to create a formula under the following criteria?
House Rent will be-of basic
1) up-to Tk.5000 Basic*55% but not less than Tk. 2500.
2) Tk. 5001-10800 Basic*50% but not less than Tk. 2800.
3) Tk. 10801-21600 Basic*45% but not less than Tk.5400.
4) Above Tk. 21600 Basic*40% but not less than Tk. 9700.
Emon
I Have this kind of problem too- thanks Sohel Rana
(Can anybody help me to create a formula under the following criteria?
House Rent will be-of basic
1) up-to Tk.5000 Basic*55% but not less than Tk. 2500.
2) Tk. 5001-10800 Basic*50% but not less than Tk. 2800.
3) Tk. 10801-21600 Basic*45% but not less than Tk.5400.
4) Above Tk. 21600 Basic*40% but not less than Tk. 9700.)
Annemarie
A sports complex involves a capital outlay of £2400.000 profits before depreciation each year would be £50.000 for six years.The cost of capital is 12%.Is the project worthwhile? use an discount cash flow technique to calculate the new present valve and assess wheather the project is worthwhile
annemarie
does anyone help on here
roofing
Many firms offer online services roofing and they can give fair suggestions and cost
effective. Better still; just visit some of the factors that
are mentioned help you to get the best.
bbb Fort Collins
Moreover, today there are capitol roofing various supplies being used and serve as a consultant, bid processor, and supplier.
Generally they are a result of the constant innovation in the roofing trade sometimes attracts shady contractors
who are not licensed can be extremely durable.
Blythe
I have read a few just right stuff here. Definitely value bookmarking for revisiting.
I wonder how so much effort you place to create
the sort of great informative site.
razaukkarim
need a book. for Ecel
Jayesh Patel
ABC1001 JOM 50 50
ABC175 ROM 100 350
ABC175 ROM 50 0
ABC175 ROM 200 0
ABC175 KOM 100 100
ABC175 ONM 100 100
ABC175 JOM 50 200
ABC175 JOM 150 0
ABC199 JOM 100 100
ABC200 ONM 100 200
ABC200 ONM 100 0
ABC7777 ONM 100 100
ABC888 ROM 100 100
ABC9099 KOM 100 100
Plz Help Me Same Code A Column And B Column then sum c Column How ???
NAVNIT PATEL
I WANT TO THIS BOOK
bet365
I really enjoyed reading an article, really amazing
Please Leave a Comment!