I have built a Pro Forma Model that reflects the full amount of an Annual SW license in the month it is BOOKED. I am looking for suggestions or examples of how to have a second tab that is based on the bookings and spreads the booking out over 12 months when REVENUE can be recognized. I...
How do I write a formula so that an annual fee shows every 12 months?
Row 10: I have months listed: 1/30/23, 2/28/23 ... etc until 12/31/24.
Row 11: Hard code of Fee and Date annual payment starts. I want to annual fee to show only in June 23 and June 24 (and be able to pick up in future years...
I now use Excel for Mac instead of the Windows version where I regularly used Power Pivots. How can I link tables and create Pivots that pull data from multiple tables in Excel for Mac? What are the best add-on, work arounds for the limitations of Mac version for pivot tables, data analysis...
This is great! However, I think I worded my question wrong. I am looking to determine the value (ie. # of parts sold) so that I start selling parts in 8/2018 and by 12/2025 have sold, cumulatively, 5 Billion parts.
Start value 1
Cumulative end value 5Billion
Thanks
Thanks, This is helpful. How do I adjust the the formula though if I need to change when the first payment is made? For example, I receive 1st Payment April 2019 and 2nd payment July 2019. With the current formula, its coming back with 2nd payment in May, not 3 months later.
Hi - I am trying to figure out how to write a formula for linear growth.
I have a Start Value of 1 and End Value of 5,000,000,000. The Start value is in Current month Aug 2018 and the End Value is in month Dec 2025.
Not sure where to start - growth, forecast, interpolation?
Please help!
I am trying to write a MOD formula so that a Fixed Value appears every 3rd month AFTER an initial value.
For example, I expect an upfront Payment value or $400K in Aug 2018. I want a reoccurring payment value of $500K starting in Nov 2018.
How do I write the formula so the Reoccurring value...
I am trying to write a formula for a tiered payment table. The sum of all payments must equal $75,000 and be spread across various tiers, with each payment being higher than than next. I am stumped.
File is attached
Thanks.
Hi
I've been trying to use COUNTIF to calculate the number of employees in different departments by month based on a table of employee salary by month. What formula should I use? I've tried COUNTIF and INDEX/MATCH, but can't get it work.
File is attached
Thanks
Hi
I've am running into circular reference issues when modeling out $s needed to maintain % of Total. I also having trouble with writing formula so one row automatically increases 20%, while keeping the Sum of the Col at 100%.
I've put text box notes in the file to better explain.
Thanks.
Hi
Point taken about the finance terminology.
1) FOR ROWS 37-40, COL T, TRYING TO BUILD FORMULA THAT WILL RESULT IN THE $ AMOUNT THAT WILL MAKE COL R % NUMBERS THE SAME AS COL J.
HOW DO TO THIS WHEN COL R IS BASED ON TOTAL IN COL Q/ROW 46?
COL R NEEDS TO TOTAL 100%
2) HOW TO MAKE COL N...
I am modeling out a Cap Table Scenarios for new round of funding.
1) I looking to determine how much money current investors would need to invest to maintain their ownership %.
2) I am also looking for a way to have a stock option pool be 20% of Total shares.
I am hitting a wall due to...
Thank you! One more feature to the formula.
If I drag the formula below across the rows, it shows payment each quarter every year. I have a multi-year table.
How would I write it so payment occurs only in 2019?
Thanks...
Also, I have multiple contracts with different payment start dates. The MOD formula only seems to work if the payment date starts in the 2nd month (2 i.e Feb).
Thanks - One point I should have been more clear about is the payment table starts with 2018.
How do I revise the above formula so result is 0 for all months in 2018, and then shows $25,000 starting in Feb 19? With the current formula it shows paymetn for 2018 too. Update file is attached.
I am trying to write a formula to show quarterly payments for the next 5 years.
The Start Date is Feb-19
Qtrly Payement is $25,000
I've tried various forms of IF(AND but its not working.
HELP!
FILE IS ATTACHED.
I am trying to write a Nested IF AN Formula
The below formula works for w having only two conditions (A2,B2).
If written it so =IF(AND(A18>=A2,A18<=B2),C2,D2)
How can I write a NESTED FORMULA to have multiple conditions ie. Row 2, Row 3, Row 4?
Attached is the table I am working on.
Actually I think it is because of scenarios. I am trying to sum quarters for three different scenarios. The scenarios are linked to another tab where I have to select an number for the scenarios (1 for scenario 1, 2 for scenario 2, 3 for scenario 3). It is only showing sums for one scenario...
I am trying to sum monthly columns into Quarter columns . In row 2, I entered the sum formulas and it worked. I then dragged the formulas down the row 8. Strangely in some rows the formula works (3,4,5) but then starting with row 6 it reverts back to showing the same results as row 2, which...
I just switched to using a MacPro and downloaded Office 365. My cursur in Excel is now a white cross and periodically changes to different shapes. How do I change the cursor to be a black arrow and STAY a black arrow - which I had when using a PC with Office 2017.
The cursor in other apps...
About 50% of the time I try to use PowerPivot I get the below error message.
"We couldn't load the PowerPivot Add-in. First try Office Repair to fix this issue. The error below should help if that doesn't work. Object reference not set to an instance of an object."
What does this mean? I've...
I am building a 5 yr depreciation forecast and am having trouble with creating the correct formula. I am trying to build an excel table with Col A the Fiscal Year the Capital is purchased, Col F-I, the Qtr the capital is purchased and Col K the life of the asset. I am trying to get the...
That's great. Thank you! Now what if I have spend in Q1 and Q3 on a single row? How can the formula be adjusted to calculate Q1 Depreciation starting in August at $1.9K to January, then start to be $4K in Feb? I attached a file. I really appreciate the help! I've been pulling my hair out...