All figures below are Annual budgetary estimates ($) for Year 1. b) Year 2 budgetary estimates are
Fantastic news! We've Found the answer you've been seeking!
Question:
All figures below are Annual budgetary estimates ($) for Year 1.
b) Year 2 budgetary estimates are at 26% revenue growth from previous year, C&B increase due to COLA is 3% for inflation from Y1 to Y2 and subsequently 3.4% in Y3.
c) Year 3 budgetary estimates are at 27% revenue loss from Year 2, Cash on hand depleted by 10%. (possibly due to COVID losses)
d) See Available financial information below to make your interpretations and AFM decisions. Rev from source A: $17,000,000
- Rev from source B: $ 900,000
- Rev from source C: $ 3,000,000
- Rev from source D : $(1,000,000)
- Company owns a warehouse that is worth $12,000,000
- Company also owns technology assets that are worth $290,000 in Y1, technology assets depcrieated in value in Y2 by 20%, and Y3 by 20%.
- Company pays rent for office in high rise building in loop $300,000 in Year 1, rent went up in Y2 by 5% and due to covid, rent in Y3 fell down by 40%.
- Ongoing administrative cost & including utilities is averaging at $500,000 (solid 50% is allocated for utilities), YOY, however they fell by 35% in Y3.
- Ongoing Travel and living cost averaging $300,000 for Y1 and Y2, then fell by 50% in Y3.
- Ongoing subscriptions for software & other services $10,000 per month and remained unchanged until Year3
- Company cars leasing at $100,000 /Yr.
- Cash on hand for C&B $5,000,000 at the beginning of the year.
- 5 employees each C&B $70,000/yr.
- 3 C-level officers each C&B $150,000/Yr.
- Marathon Informatics E.H.R services averaging $150,000
- Revenue write offs from, RCM billing discrepancies due to ICD error in claims & denials $250,000 each yr. (Rev, write off is a cash liability)
- Separately, the company is interested in acquiring a test E.H.R system for training clients and employees at $150,000.
- Is this a good investments, demonstrate by C&B ratio.
- When do they break even in year 1? (Each training is priced at $1,500/per unit and requires subscription services averaging at $5,000/per unit.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: