{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Resource Assessment","Shortfall","Instructions","Standards"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Resource Assessment","index":0,"n_rows":122,"n_cols":3,"rows_kept":122,"cut":false,"hidden":false,"merged":[[107,0,107,2],[1,0,4,0],[57,3,57,4],[46,4,46,6],[12,0,12,2],[13,4,13,6],[36,4,36,6],[98,0,98,2],[99,0,99,1]]}
[null,"Branch:"]
["2025 OPI-M \nResource Assessment"]
[null,"Case name:","ONE case number:"]
[null," "]
[null,"Date assessment requested:","Worker name:"]
[]
[null,"Date assessment completed:","Continuous period of care start date:"]
[]
["Applicant's name:","DOB:","SSN:"]
[]
["Community spouse's name:","DOB:","SSN:"]
[]
["Step 1: Enter the countable value of the below items owned by the applicant and/or spouse."]
["1. Liquid resources ","On the date care started","Now"]
["Bonds:"]
["Cash:"]
["Certificate of deposit:"]
["Check:"]
["Direct Express card:"]
["Nursing Facility resident account:"]
["Reloadable money card:"]
["Checking account:"]
["Escrow account sponsored by HUD:"]
["Foreign cash:"]
["Individual development account:"]
["Individual education account (IEA):"]
["Mutual fund:"]
["Pension/retirement plan:"]
["Savings account:"]
["Securities:"]
["Stocks:"]
["Trust fund:"]
["Sales contract:"]
["Other:"]
["Total countable value:",{"$f":"SUM(B15:B34)","v":0},{"$f":"SUM(C15:C34)","v":0}]
[]
["2. Vehicles","On the date care started","Now"]
["Car:"]
["Truck:"]
["Boat:"]
["Camper:"]
["Motor home:"]
["Motorcycle:"]
["Trailer:"]
["Aircraft:"]
["Snow mobile:"]
["Other:"]
["Total countable value:",{"$f":"SUM(B38:B47)","v":0},{"$f":"SUM(C38:C47)","v":0}]
[]
["3. Life insurance and burial ","On the date care started","Now"]
["Life insurance:"]
["Prepaid burial agreement:"]
["Burial space/merchandise:"]
["Whole life insurance:"]
["Burial insurance:"]
["Total countable value:",{"$f":"SUM(B51:B55)","v":0},{"$f":"SUM(C51:C55)","v":0}]
[]
["4. Real property and life estate","On the date care started","Now"]
["Residential Property:"]
["Business Property (Non Rental):"]
["Rental Property:"]
["Life Estate:"]
["Other:"]
[" Total countable value:",{"$f":"SUM(B59:B63)","v":0},{"$f":"SUM(C59:C63)","v":0}]
[]
["5. Annuities, trusts, loan/property agreements","On the date care started","Now"]
["Annuities:"]
["Trusts:"]
["Property agreement:"]
["Promissory note:"]
["Loan/property agreement:"]
["Mortgage:"]
[" Total countable value:",{"$f":"SUM(B67:B72)","v":0},{"$f":"SUM(C67:C72)","v":0}]
[]
["6. Other resources","On the date care started","Now"]
["Deferred payment loan:"]
["Home equity line of credit (HELOC):"]
["Other investments:"]
["Reverse mortgage:"]
["Sale lease back:"]
["Time share:"]
["Mineral/oiI rights:"]
["Oil rights:"]
["Inventory not related to self-employment:"]
["Animals (not income-producing):"]
["Personal belongings:"]
["Other:"]
["Total countable value: ",{"$f":"SUM(B76:B87)","v":0},{"$f":"SUM(C76:C87)","v":0}]
[]
["Calculation of all countable resources","On the date care started","Now"]
["Section #1:",{"$f":"B35","v":0},{"$f":"C35","v":0}]
["Section #2:",{"$f":"B48","v":0},{"$f":"C48","v":0}]
["Section #3:",{"$f":"B56","v":0},{"$f":"C56","v":0}]
["Section #4:",{"$f":"B64","v":0},{"$f":"C64","v":0}]
["Section #5:",{"$f":"B73","v":0},{"$f":"C73","v":0}]
["Section #6:",{"$f":"B88","v":0},{"$f":"C88","v":0}]
[" Total countable resources:",{"$f":"SUM(B91:B96)","v":0},{"$f":"SUM(C91:C96)","v":0}]
[]
["Step 2: Determine the community spouse's share of resources"]
["Half of total countable resources at the start of care:",null,{"$f":"B97/2","v":0}]
["Maximum community spouse resource standard:",null,{"$f":"Standards!F3","v":157920}]
["Smaller of the two lines above:",null,{"$f":"MIN(C100,C101)","v":0}]
["Minimum community spouse resource standard:",null,{"$f":"Standards!F2","v":31584}]
["Court-ordered community spouse resource allowance:",null,0]
["Complete the \"Shortfall tab\" to calculate spouse's amount necessary to generate Income:",null,{"$f":"Shortfall!C44","v":0}]
["Largest amount (actual CSRA):",null,{"$f":"LARGE((C102:C105),1)","v":31584}]
[]
["Step 3: Determine applicant's resource eligibility"]
["Countable resources now:",null,{"$f":"C97","v":0}]
["Subtract spousal allowance:",null,{"$f":"C106","v":31584}]
["Resources available to client:",null,{"$f":"IF(C109-C110<0,0,C109-C110)","v":0}]
["OPI-M resource limit for one person:",null,{"$f":"Standards!F8","v":99656}]
["Amount of excess resources as of the date this RA was completed:",null,{"$f":"IF(C111-C112<0,0,C111-C112)","v":0}]
["To be eligible, the couple's total resources cannot exceed (CSRA + $99,656.00):",null,{"$f":"C110+C112","v":131240}]
["Resource eligibility decision:",null,{"$f":"IF(C109>C114,\"Ineligible\",\"Eligible\")","v":"Eligible"}]
[]
["Important! This calculation will change if your resources change. Please notify your worker if your resources change."]
[]
["Need this document in another format? You can get this letter in other languages, large print, braille, or a format you prefer for free. Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5600 (voice/text). We accept all relay calls."]
["You can get this letter in other languages, large print, braille, or a format you prefer for free. Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5600 (voice/text). We accept all relay calls."]
["Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5811 (voice/text). "]
["We accept all relay calls."]

{"sheet":"Shortfall","index":1,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["                    Community Spouse Income Shortfall Calculator"]
[]
[" Calculate recipient's income"]
["a. Earned income amount:"]
["b. Unearned income amount:","+"]
["c. Other income amount:","+"]
["d. Standard earned income deduction of $65:","-",{"$f":"IF(C4>65,65,C4)","v":0}]
["e. OSIPM maintenance for in-home services:","-",{"$f":"Standards!F9","v":1467}]
["Recipient adjusted income:","=",{"$f":"IF((C4+C5+C6-C7-C8)<0,0,(C4+C5+C6-C7-C8))","v":0}]
[" Calculate community-spouse income allowance "]
["a. Community spousal allowance standard is $2,643.75:",null,{"$f":"Standards!F4","v":2643.75}]
["b. Shelter expenses:  Rent or mortgage"]
["                              Taxes/insurance","+"]
["                              Federal Utility Allowance (FUA)","+",{"$f":"Standards!F5","v":515}]
["                              Total shelter expenses","=",{"$f":"(C12+C13+C14)","v":515}]
["     Shelter allowance:","-",{"$f":"Standards!F6","v":793.13}]
["     Total allowance:","=",{"$f":"MIN(3948,IF(C15>C16,C15-C16,0))","v":0}]
["     Subtotal (CAP of $3,948.00)",null,{"$f":"C17","v":0}]
["c. Spouse's gross countable income"]
["Total community spouse income allowance:",null,{"$f":"IF((C18-C19)>0,C18-C19,0)","v":0}]
["Calculate dependent income allowance (skip if no eligible dependents)"]
["     Dependent allowance standard:",null,{"$f":"Standards!F7","v":2643.75}]
["     Number of eligible dependents:","X"]
["     Subtotal:","=",{"$f":"C22*C23","v":0}]
["     Eligible dependents' total gross monthly income:","-"]
["     Subtotal:","=",{"$f":"IF((C24-C25)>0,C24-C25,0)","v":0}]
["    Dependent allowance :","=",{"$f":"C26/3","v":0}]
["List deductions allowed from recipient income"]
["a. Community spouse income allowance:",null,{"$f":"C20","v":0}]
["b. Dependent income allowance :","+",{"$f":"C27","v":0}]
["c. Possible income diversion to spouse (LDS):","=",{"$f":"C29+C30","v":0}]
["d. Actual LDS amount.:",null,{"$f":"IF(C9<C31,C9,C31)","v":0}]
["Spouse income shortfall",null,{"$f":"C20-C32","v":0}]
[{"$f":"IF(C33=0, \"No shortfall. Return to Resource Assessment tab.\", \"There is a shortfall. Continue to next step.\")","v":"No shortfall. Return to Resource Assessment tab."}]
["Determine the single-point annuity amount "]
["1- Open the Fidelity Annuity Calculator"]
["2- Check \"Just Me\" and enter the spouses information"]
["3- Do not select \"I'd prefer income for a set number of years.\""]
["4- Enter the community spouse's date of birth, gender and state of residence. "]
["5- Check \"How much I want to get each month\""]
["6- In \"Amount\", enter the shortfall from the above calculation in whole dollars."]
["7- Under \"Funding Source\" select Nonqualified"]
["8- Select \"See my results\""]
["9- Enter the amount listed next to \"Cash Refund\" here  ----------->",null,0]
["Return to the Resource Assessment tab"]
["Need this document in another format? You can get this letter in other languages, large print, braille, or a format you prefer for free. Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5600 (voice/text). We accept all relay calls."]

{"sheet":"Instructions","index":2,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Instructions for completing the OPI-M resource assessment worksheet"]
["Before you begin: \n   • Calculations on this form are specific to OPI-M. Do not use this form for other programs.\n   • This form does not determine what resources are countable. For more information see \"Treatment of Specific Assets\" section in OPEN  (Chapter 2 Eligibility, Section 5 Financial Eligibility). \n   • You will only complete the blue-shaded cells. \n   • Pre-filled cells are based on the current years standards. Make sure you are using the current year's worksheet.\n\n"]
["1. Complete applicant and community spouse personal information"]
["Branch - enter your branch"]
["Case name - name of individual requesting OPI-M"]
["ONE case number - enter if applicable"]
["Date assessment requested - for courtesy RAs only"]
["Date assessment completed - enter date the RA is complete, not the date it was started"]
["Applicant's name, DOB, SSN - enter info of individual seeking OPI-M services"]
["Community spouse's name, DOB, SSN - enter info from spouse of applicant"]
["Case mailing address - enter the address where the RA should be mailed."]
["Continuous period of care start date - The date the person started getting care in their home or a facility. The date resets if there is a break in care 30 days or longer. *Note: \"Care\" means they were getting help with mobility, elimination, eating, or cognition. *See OAR 411-015-0005 for definitions of these terms."]
["Name and address of place of care - Enter address of where applicant is currently or will be receiving care (paid or unpaid). "]
["2. Enter countable resources for sections 1 through 6. "]
["In each category, combine both the applicant's and community spouse's countable resources (per policy) at the start of care and resources available now."]
["3. Resource assessment calculations"]
["Determination of countable resources"]
["This section totals the value of the countable resources entered above."]
["Determine the community spouse's share of resources"]
["This figure represents half of the total of the couple's countable resources at the beginning of the \ncontinuous period of care."]
["Determine the CSRA"]
["This section calculates the potential community spouse resource allowance (CSRA) "]
["If applicable, enter the court-ordered community spouse resource allowance (not common)"]
["Complete the calculation on the shortfall tab. This will calculate and populate the amount of resources needed to generate income if there is an income shortfall for the community spouse."]
["4. Determine applicant's resource eligibility"]
["This section displays the applicant's resource eligibility based on the current value of the couple's resources versus what it was at the beginning of the continuous period of care."]
["The form displays the eligibility decision based on the calculations entered above."]
[]
["Need this document in another format?"]
["You can get this letter in other languages, large print, braille, or a format you prefer for free."]
["Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5811 (voice/text). "]
["We accept all relay calls."]

{"sheet":"Standards","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["2025 Standards used in determination"]
["Min. Community Spouse Resource Allowance",null,null,null,null,31584]
["Max. Community Spouse Resource Allowance",null,null,null,null,157920]
["Community Spousal Allowance Standard",null,null,null,null,2643.75]
["Federal Utility Allowance",null,null,null,null,515]
["Shelter Allowance",null,null,null,null,793.13]
["Dependents Allowance Standard",null,null,null,null,2643.75]
["OPI-M Resource Limit for one person",null,null,null,null,99656]
["OPI-M Maintenance for in-home services",null,null,null,null,1467]
[]
["Need this document in another format?"]
["You can get this letter in other languages, large print, braille, or a format you prefer for free."]
["Contact ODHS at apd.ltss@odhsoha.oregon.gov or at 503-945-5811 (voice/text). "]
["We accept all relay calls."]