5. The analysis has considered the clinic's near-term profitabilitythat is, an average month in 2018. Recast the pro forma (forecasted) profit and loss statement developed in Question 1 for an average month in 2023, five years hence, assuming that volume is constant over time. (Hint: You must consider likely changes in revenues and costs due to inflation and other factors. The idea here is to see if the clinic can "inflate" its way to profitability even if volume remains flat.)

Pro Forma Average Month: Pro Forma For The Year: Number of visits 1,230 14,762 Net revenue $47,037 $564,448 Salaries and wages Physicians fees Malpractice insurance Travel and education General insurance Subscriptions Electricity Water Equipment rental Building lease Other operating expenses Total operating expenses $12,952 $16,286 $2,705 $469 $700 $14 $998 $110 $105 $12.910 $8,561 $55,810 To complete this input, choose the historical values from above that represent the best estimates for the average month for the entire coming year. $155,429 $195,429 $32,460 $5,630 $8,398 $162 $11,977 $1,317 $1,260 $154,924 $102,732 $669,718 Operating income (loss) ($8,773) ($105,270) Operating margin (%) 7% 18.7% Incremental Monthly Costs: Number of Additional Visits per Day 1-10 11-20 21-30 0 31-40 Variable costs: Medical supplies Administrative supplies Total variable costs per visit $5.00 per visit 2.00 per visit $7.00 per visit Semifixed costs: Salaries and wages Physician fees Total monthly semifixed costs $5,000 12,000 $17,000 $6,000 12,000 $18,000 $7,000 12,000 $19,000 $8,000 12,000 $20,000 $0 Fixed costs: Marketing assistant's salary Advertising expenses Total monthly fixed costs $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4,000 $7,000 Pro Forma Average Month: Pro Forma For The Year: Number of visits 1,230 14,762 Net revenue $47,037 $564,448 Salaries and wages Physicians fees Malpractice insurance Travel and education General insurance Subscriptions Electricity Water Equipment rental Building lease Other operating expenses Total operating expenses $12,952 $16,286 $2,705 $469 $700 $14 $998 $110 $105 $12.910 $8,561 $55,810 To complete this input, choose the historical values from above that represent the best estimates for the average month for the entire coming year. $155,429 $195,429 $32,460 $5,630 $8,398 $162 $11,977 $1,317 $1,260 $154,924 $102,732 $669,718 Operating income (loss) ($8,773) ($105,270) Operating margin (%) 7% 18.7% Incremental Monthly Costs: Number of Additional Visits per Day 1-10 11-20 21-30 0 31-40 Variable costs: Medical supplies Administrative supplies Total variable costs per visit $5.00 per visit 2.00 per visit $7.00 per visit Semifixed costs: Salaries and wages Physician fees Total monthly semifixed costs $5,000 12,000 $17,000 $6,000 12,000 $18,000 $7,000 12,000 $19,000 $8,000 12,000 $20,000 $0 Fixed costs: Marketing assistant's salary Advertising expenses Total monthly fixed costs $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4.000 $7,000 $3,000 4,000 $7,000