Ask Basic Finance Expert

No one can predict the future, but accountants and financial managers must try and do exactly that!  By examining net revenue, costs, and cash flow, you can get a clearer picture of what to expect in your organization's (or one with which you are familiar) fiscal future. Using these metrics to look forward will enable you to more effectively plan budgets that accomplish organizational goals.

In this Assignment, you address three scenarios. One scenario focuses on net revenue, another revolves around fixed and variable costs, and the third presentsinformation on cash flow. You will use the information provided in the scenarios to answer questions and explore how net revenue, fixed and variable costs, and cash flow impact the ability of an organization to provide services. You will also consider the different categories of costs.  A Work template is provided as an example.  You will need to put create this template in Excel and add the necessary values and calculations.

Note: For those Assignments in this course that require you to perform calculations you must:

  • Create an Excel spreadsheet containing the information provided.  Template in Word is provided.
  • Show all your work.
  • Answer any questions included with the problems (as text in the Excel spreadsheet).

For those not comfortable with the use of Microsoft Excel, this week's Optional Resources suggest several tutorials.

To prepare:

  • Review the information in this week's Learning Resources (including the Media) dealing with net revenue, fixed and variable costs, and cash flow and how they are used in financial decision making.
  • Carefully examine the information in each of the three scenarios below and consider how calculations using this information can be used to answer the questions asked.

Net RevenueScenario

Yourclinic provides fourkinds of services:

Comprehensiveinitialmedical consultationispricedat $250

  • Establishedpatient limitedvisit is pricedat $75
  • Establishedpatient intermediatevisit is pricedat$125
  • Establishedpatient comprehensivevisit is pricedat $250

Question: The profile of your patients is such that the average collection rate is 75%. Assuming you have 100 visits of each type each month, what amount of new revenue will you generate in the next 12 months? 

Template for the Net Revenue Scenario

 

Ta

 

 

Annual Volume

Gross Revenue

 

 

 

 

Type of Service

Price Each

 

Comprehensive initial medical consultant

 

 

 

 
 
 

Established patient limited visit

 

 

 

 

Established patient intermediate visit

 

 

 

 

Established patient comprehensive visit

 

 

 

 

Total Gross Revenue

 

 

 

 

Average Collection Rate

 

 

 

 

Total Net Revenue

 

 

 

 

 

Fixed/VariableCostScenario

 

Youhaveperformedacost analysis of yourhealthserviceorganizationandhave determinedthefollowing: basedonthelatestthreeyears ofinformation, yourannual cost ofoperations is $1,600,000withannual volumeof 10,000procedures. Youhave determinedthat certainofyoursupplyitems arefixedinnature(thosemarkedwithan F) whileothers arevariable(markedwithaV).

 

 

 

 

Cost Items

 

 

 

F/V

Average Annual Amount

 

 

 

Cost Items

 

 

 

F/V

Average Annual Amount

Supplyitem1

F

$220,000

Supplyitem6

F

50,000

Supplyitem2

F

180,000

Supplyitem7

V

500,000

Supplyitem3

F

75,000

Supplyitem8

V

300,000

Supplyitem4

F

50,000

Supplyitem9

V

200,000

Supplyitem5

F

25,000

Total

 

1,600,000

 Question: Aninsurance company that is considering directing its 1,000units peryearof procedurebusinesstoyourorganizationhasapproachedyou. Yourboardhasmandatedthatyoumake$5of profitfromeachof theprocedures. You obviously want thehighestpossibleprice,butas youenterthenegotiations, what isthe lowest possiblepriceyouwouldbewillingtoacceptfromthispayer? 

Hint: Calculate the variable cost.

Template for the Fixed/Variable Cost Scenario

SupplyItem

Total

Variable

Fixed

SupplyItem1

 

 

 

SupplyItem2

 

 

 

SupplyItem3

 

 

 

SupplyItem4

 

 

 

SupplyItem5

 

 

 

SupplyItem6

 

 

 

SupplyItem7

 

 

 

SupplyItem8

 

 

 

SupplyItem9

 

 

 

                                 Total

 

 

 

AnnualVolume

 

 

 

VariableCost per Unit

 

 

ProfitTarget

 

 

Total

 

 

Cash Flow Scenario

Your new business venture will begin operationon July1,20X2. Youwill hirestaff effectiveJanuary1, 20X2withacost of $40,000per month. Youknowfromexperience that collectionslagbillingby3 months (inotherwords, onceyoubill foraservice, you must wait 90days forthepaymenttobereceived. Yourbusinessvolume is projectedto beasfollows:

Month

Volume

Billing

July, 20X2

1,000

$100,000

August

1,000

$100,000

September

1,000

$100,000

October

1,000

$100,000

November

1,000

$100,000

December

1,000

$100,000

January, 20X3

1,000

$100,000

February

1,000

$100,000

March

1,000

$100,000

April

1,000

$100,000

May

1,000

$100,000

June

1,000

$100,000

 

Question: If youhave$380,000of cashonhandJanuary1, 20X2,howmuchcashwill youhaveat theendof June20X3?ssumea100%collectionrate.

 

Template for the Cash Flow Scenario 

 

 

Month

Opening

Cash Balance

 

Monthly Expense

 

Monthly Billing

 

Monthly Collections

Ending Cash Balance

January20X2

$380,000

$40,000

 

 

$340,000

February

$340,000

 

 

 

 

March

 

 

 

 

 

April

 

 

 

 

 

May

 

 

 

 

 

June

 

 

 

 

 

July

 

 

 

 

 

August

 

 

 

 

 

September

 

 

 

 

 

October

 

 

 

 

 

November

 

 

 

 

 

December

 

 

 

 

 

January20X3

 

 

 

 

 

February

 

 

 

 

 

March

 

 

 

 

 

April

 

 

 

 

 

May

 

 

 

 

 

June

 

 

 

 

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M9214599
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in Basic Finance

Question utilizing the concepts learned throughout the

Question: Utilizing the concepts learned throughout the course, write a Final Paper on one of the following scenarios: • Option One: You are a consultant with 10 years experience in the health care insurance industry. A ...

Discussion your initial discussion thread is due on day 3

Discussion: Your initial discussion thread is due on Day 3 (Thursday) and you have until Day 7 (Monday) to respond to your classmates. Your grade will reflect both the quality of your initial post and the depth of your r ...

Question financial ratios analysis and comparison

Question: Financial Ratios Analysis and Comparison Paper Prior to completing this assignment, review Chapter 10 and 12 in your course text. You are a mid-level manager in a health care organization and you have been aske ...

Grant technologies needs 300000 to pay its supplier grants

Grant Technologies needs $300,000 to pay its supplier. Grant's bank is offering a 210-day simple interest loan with a quoted interest rate of 11 percent and a 20 percent compensating balance requirement. Assuming there a ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

You are planning to make annual deposits of 4440 into a

You are planning to make annual deposits of $4,440 into a retirement account that pays 9 percent interest compounded monthly. How large will your account balance be in 32 years?  (Do not round intermediate calculations a ...

One year ago you bought a put option on 125000 euros with

One year ago, you bought a put option on 125,000 euros with an expiration date of one year. You paid a premium on the put option of $.05 per unit. The exercise price was $1.36. Assume that one year ago, the spot rate of ...

Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide f ...

Call optionnbspcarol krebs is considering buying 100 shares

Call option  Carol Krebs is considering buying 100 shares of Sooner Products, Inc., at $62 per share. Because she has read that the firm will probably soon receive certain large orders from abroad, she expects the price ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As