Project Name: Financial calculation web application
Description: I need magic makes the financial computations.
This organization runs 10 Continuing Care Retirement Communities in 3 western states. We have about 5500 elderly residents that we care for.
Once someone joins our community they can move from Independent Living, to Assisted Living, to Skilled Nursing, all within our campus. As part of our role as a non-profit we promise that if a person is admitted to our facility they can stay there even if their money runs out through no fault of their own.
This means that doing the financial analysis to qualify a resident to join a community is a very important activity. If we do it wrong we either lose money, or refuse to admit people who in fact qualify.
We currently use a simple web based application with 14 data entry screens created by a â€˜long goneâ€™ contractor. Itâ€™s called Margin Magic, and was created specifically to do this fundamental financial analysis. In that application we enter all the potential residents assets including stocks, home value, cash, insurance, bonds, retirement accounts, social security payments, interest payments and so on. We also enter the â€˜buy inâ€™ price of the community, monthly maintenance costs, and expected yearly percentage increase in maintenance. Once that data is entered Margin Magic makes the financial computations needed and produces a set of reports that we use in discussion with the potential residents. Since personal financial data is being entered the application needs user level security (unique name and password) and perhaps the encryption of stored data.
Weâ€™re looking for a small company to essentially re-create this application using the tools of your choice given we are a 100% Microsoft environment. Additionally weâ€™re looking for a partner who will be able and willing to make necessary changes and enhancements as we think of them, or as you might recommend.
Since the current paper documentation is poor Iâ€™m making part of the specification screen shots of the current application. That way you will be able to see how the tool is used and how simple (or complicated) the application actually is. Whoever gets the business will have access to the application â€˜liveâ€™ and to people who currently use it. We can provide the overall strategy for those computations and detail the computations necessary.
The deliverables would be:
1. A documented application that performs the same functions as the current Margin Magic
2. Tools to allow us to change the variables in the calculations
3. A commitment to enhance and support the application on a time and material basis
The attached contains help screens for the current application.
Timeframe: Ready to start immediately; expect initial results in 1 months.