cash

Hello, A spreadsheet I recently inherited has hard coded numbers, I was hoping someone could help me with the formulas to recompute a couple columns (PV Cash & Interest Exp) that I can't seem to re-create. Discount rate is 10%, term is 1/1/2020 - 12/31/2020, it's on a 13 period fiscal year...

Hello everyone and please pay a smile when you work this because it's a pain... I have a table and I'd like to return an amount based on criteria. Let me explain below: <tbody> Financial Figures (SR'000) Salama Yearly Change(%) Cash & Cash Equivalents 2013 Insurance...

Hello Guys and smile where ever you be... I have a table (below) and trying to find the LARGER number (in a separate cell) which is ok with me. However, I'd like to return the text which is particular to that number. Let me illustrate more: <tbody> Company Cash on hand and at banks Term...

I have an excel file having nine sheets. Each sheet is having different tables. I need a macro to copy the cell values containing a particular substring and the values against those cells in the third right column and paste the same in two specific columns of excel sheet of a different excel...

Hi all, What I have is a relatively simple data set. I'd like to graph it so that the Revenue entries appear as clustered columns, and the Cash entries appear as markers right above (or inside) the corresponding revenue column. Using a combo graph, I'm able to get the columns and markers to...

Hi, I'm trying to get my head around building this into our finances sheet and not sure where to start. What I want to do is have something like this https://www.calculators.org/budget/ - I want to specify a accounts with percentages and want to specify say a surplus of cash, and then divide...

Hello, I have a series of cash outflows and inflows over 144 months. The first 24 months are cash outflows - the next 120 month cash inflows. My sheet is set up as follows Row 1 - Numbered 1-144 Row 2 - Months (Beginning 8/1/18 thru 144 months) Row 3 - Cash flows Currently my sheet calculates...

What is the easiest way to sum all "GL No" from 1000-1099 in range A2:D9 relating to cash in Table 1 and place total into cell A2 in Table 2? ...2200-2299 in "Inventory" on Table 2 and 5000-5099 in "Payable" on Table 2 . I have created a helper column but there must be a better way.....any...

Hi all, I would like to create a Drop Down List in cell “A1”, so that to choose any month and then to appear the data in the current Spreadsheet. Note that the months are belong to another file, named Cash Sales Table. In sch. 1. are the original data and in sch. 2. Is the expected result...

Good afternoon, Sorry if this is repeated by I'm not even sure how to work this. I have a call that has the value "Total Cash". I am using this to find the cell. I can also use find and replace. Cells.Find(What:="TOTAL CASH", After:=ActiveCell, LookIn:=xlFormulas, _...

Hi, I have an IRR related query, which I am struggling to resolve, any advice would be most appreciated. <tbody> 30/04/2018 0 31/05/2018 0 30/06/2018 -100 31/07/2018 0 31/08/2018 200 30/09/2018 20 31/10/2018 20 30/11/2018 10 </tbody> I am trying to calculate the IRR of the...

Hello everyone, I have a very specific excel question in regards to calculating the daily cash drop for a restaurant. Every day at my restaurant we start with $300 in the cash drawer across all amounts of change and bills. At the end of the day, the person closing counts the total amount of...

...based on a date that falls between two given dates. For example, I collected $100 on April 15 and another $200 on April 20. I need a formula that sums up all cash received in April between April 1 and April 30. Thanks!

Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...

Is it possible to calculate a Future Value that has an NPV of 0 without using goal seek or VBA? I have an investment in stock quantity (D3) and price (D4) to calculate a cash outflow (D5). I have a return rate (D8) of 10% and a holding period (D7) in months and there are no other cash inflows...

Hello, How do I write a code to highlight everything, including the blank lines? I need to highlight and copy everything in B1:E7, and I seem to be stuck at just highlighting B1:E2. ActiveCell.CurrentRegion.Select isn't giving me much joy. I'm stuck in a virtual loop! Thanks for your help...

Hello, How do I write a formula to: 1. Determine if a cell is labelled "Cash", "Cheque" or "EFT" 2. If it is then I need to concatenate certain cells together. Example: Thanks for your help. Best wishes, Peggy <tbody> A B C D E F 1 Cash Stationery {formula = }Cash - Stationery 2...

Hello everyone! I am in need of two formulas that could possibly be the same/similar. See sample tables below: <tbody> Name Title Hours Helper Column? June Carter Cash Singer 1.33 1.83 June Carter Cash Manager 1.67 1.67 Hank Williams Singer .20 .70 Hank Williams Songwriter 1.50 4...

Hi, I am trying to create a formula, that when the trigger in column C is met (1 being trigger met), takes the cash going forward in column A to column D, until the point that the sum of the cash in column D equals % of the cumulative cash at the trigger point. For example, the trigger hits...

Hi everyone, I am happy to join to such wonderful forum. I will really appropriated if you could help this issue. I have the following table <colgroup><col></colgroup><tbody> <tbody> Day Amount Means 1 143 Bank 2 22 Cash 3 1980 <tbody> Master Card </tbody> 4 5 Debt Card 5 388...