I need help creating a spreadsheet that incorporates a sinking fund for a bond/ loan. IE each year the loan amount will be lowered by the amount of excess cash that is generated from operations. The yearly interest will be calculated after excess cash from prior year taken into account-
Any ideas
Hi there.
I don't think this is even possible but it won't hurt to ask .
Can we sink events of a late bound object ie :an Object accessed/automated via the CreateObject function and therefore without being able to use the WithEvents keyword ?
For example : Use Createobject to create a new instance of a Word document and somehow capture the Word document events from excel.
Okay - let me try this again. (since I think my previous post was a bit too convoluted - even for me!)
I need to figure out the Present Value of a monthly payment of $124.00, 36 months from now, at a 10% discount rate.
Or - perhaps looking at it this way: At which month (during the 36-month period) does the $124 payment go below $111.60 in value? ($111.60 = $124*90%)
Can anyone help me with this one?
I need a formula to calculate prize money for a tournament. I need to take the prize money available and pay out to 1 in 4 participants, the minimum prize is equal to the entry fee ($20).
For example, if we have 8 participants and the prize money is $70, we'll pay out 2 places and the 2nd place would be at least $20. Prize money should be paid out in variables of $5 (5, 10, 15, 20, etc).
I need to perform a funds transfer based on the correction position held .
However the funds are in the wrong banks , How to formulate a formula to calcualate the transfers and amount needed to become the correct position.
The amounts are key in manually, but I wan to see the transfer calculated as I have Thousands of client position to correct .
I have attached a sample below
Thanks you
Funds transfer.xls
Hi all
Not sure if anyone will be able to help me but Im looking to set-up a spreadsheet which tracks and monitors fund/stock performance over time. I was wondering if anyone had any suggestions as to the easiest and most efficient way of setting up this kind of spreadsheet. I know this is a random shot in the dark but thought Id ask the question anyway.
Any help would be much appreciated.
Many Thanks
Krishna
I am working on an excel spreadsheet to show various options for financing some construction projects.
I have up to 5 projects and various ways to finance them and I would like a sophisticated way to show the effects of changing the different financing types.
When my budget gets low I have to go back and secure more financing or use an established credit line. I have limited funds and I need the spreadsheet to take the available funds into consideration. Any ideas on how to get started?
Hi I'm tracking expenses out of two funds and I'd like to know how to sum total spent each week for each fund.
I have 3 columns
Transaction | Fund | Week Number
$30.00 | Fund 1 | 2
$41.00 | Fund 2 | 2
$50.00 | Fund 1 | 2
$70.50 | Fund 1 | 4
$80.95 | Fund 2 | 4
I'd like to add two more colums: Weekly total for Fund 1 and Weekly total for Fund 2
and need a formula that is something like "for every change in Week Number, add transactions where Fund = Fund 1"
Thanks for your help
In my business, I am often asked to forward sums of cash. In order to do so, I need to requisition a fund withdrawal; the problem is when the sums are not round and I have to spend precious time figuring out the number of each denomination I have to requisition...
Example: I need to requisition $1535 - is there any way I can put that sum into one cell and input a formula (preferably not VBA as I am not proficient at all with it) into the following 4 cells so I am told automatically that I need to requisition 15 x $100 bill, $1 x $20 bill, 1 x $10 bill and 1 x $5 bill?
Thanks in advance for any help you all might be able to give me!!
Ian
I have not searched for this in the forums because I had no idea what to search for!
I want to create a spreadsheet that keeps a running tally of funds entered into a bank account. So, each week, a set amount of monies for various items is deposited into the account. I want the spreadsheet to keep a running tally of how much money has accumulated for the various items.
I am finding this difficult to explain - so bear with me.
The way i saw it working was like this:
Week 1
Item 1 $40
Item 2 $40
Week 2
Item 1 $40
Item 2 $40
Week 3
Item 1 $40
Item 1 -$15
Item 2 $40
Tally
Item 1 $105
Item 2 $120
NOTE: I don't want these items to be added manually. What I want is for each item to be flagged, so that the tally column then reads the spreadsheet and then adds all the entries for the flagged cells to then calculate the total.
I have no idea if this can be done or if this is pie in the sky stuff. But from what I have seen of the ingenious workarounds on this forum it seems at times that anything can be done.
This spreadsheet is to keep track of a personal funds account that my family uses to put money in for christmas, birthdays, car expenses, house repairs etc. I am also going to create a separate spreadsheet to keep track of accumulated funds for my business. I want to avoid the scenario where I am always manually adding these entries because firstly it is a long and complex way of doing things and secondly because it is prone to errors and lastly because it is difficult to update.
All help will be mighty appreciated.
cheers
