Case $4\mathrm{.}3.$ Using Excel to Assess the Return on Assets Ratio

PROBLEM

Goodfellow & Perkins LLP is a successful mid$-$tier accounting firm with a large range of clients across Texas. During $2025,$ Goodfellow & Perkins gained a new client, Brookwood Pines Hospital $($BPH$),$ a private, not$-$for$-$profit hospital. The fiscal year$-$end for BPH is June $30.$ Goodfellow & Perkins is performing the audit for the fiscal year$-$end June $30,2026.$ Selected amounts from BPH$\text{'}$s balance sheets as of June $30,2026$ and $2025$ are presented here.

$202620252024$

Total current assets $$233,286$ $$225,962$ $$224,694$

Total assets $1,787,7201,618,6981,618,702$

Total net assets $1,204,1391,024,9321,025,001$