tmckerahan
New Member
Hi fellow PHD fans. I'm trying to create a user-friendly Excel sheet to aid my colleagues in visualizing the fiscal year impacts of new contracts with our vendors. The contracts are always written on a calendar year basis (i.e., "the vendor will receive a sum total of $X, payable in equal quarterly installments, during calendar year 2010") but of course internally we need to translate that in terms of our fiscal year (May 1-April 30). I'd like to have a worksheet that would allow the user to input different scenarios to see their effects on different FYs. For example, what is the expected impact on each of the next 3 FYs if I pay this vendor monthly versus paying semi-annually versus paying quarterly?
I'm having a hard time figuring out where to start on this without relying on some monstrously large IF statements. Would welcome any tips or ideas anyone has. The end product really needs to be quite simple -- ideally the user would just input the contract date range and annual amount due, and then can choose among different scenarios to see what happens -- but I'm game to set up sophisticated macros or analyses in the background if necessary.
Thanks in advance for your help!
tmckerahan
I'm having a hard time figuring out where to start on this without relying on some monstrously large IF statements. Would welcome any tips or ideas anyone has. The end product really needs to be quite simple -- ideally the user would just input the contract date range and annual amount due, and then can choose among different scenarios to see what happens -- but I'm game to set up sophisticated macros or analyses in the background if necessary.
Thanks in advance for your help!
tmckerahan