Finance assignment – down east pharmaceuticals

Don't use plagiarized sources. Get Your Assignment on
Finance assignment – down east pharmaceuticals
Just from $13/Page
Order Now

Down East PharmaceuticalsKathleen Rogan of Down East Pharmaceuticals has engaged you as a consultant. Download and read the scenario. Download and use thespreadsheet for analysis.

Based on the information, do the following:

  • Develop the following first year data:
    • The company’s projected average collection period (ACP), also called days sales outstanding (DSO).
    • The company’s projected average daily sales. (Use a 360-day year.)
    • The company’s projected average receivables level.
    • The end-of-year balance sheet figures for accounts receivable and notes payable assuming that notes payable are used to finance the investment in receivables.
    • The projected annual dollar cost of carrying the receivables.
    • The receivables level at the end of March and the end of June. Note that the receivables level forecasts, and all forecasts required by the following questions, should be based on these assumptions: (a) the monthly sales forecasts given in Table 1 are realized and (b) the company’s customers pay exactly as predicted.
    • The company’s forecasted average daily sales for the first three months of operations and for the entire half year.
    • The implied ACP at the end of March and at the end of June.
    • Aging schedules at the end of March and the end of June.
  • Construct uncollected balances schedules at the end of March and at the end of June.
  • Use the uncollected balances schedule to forecast receivables levels at the ends of March and June for the second year of operations.

This data is to be presented to venture capitalists who will ask questions concerning both the interpretation of the receivables data and the sensitivity of the results to the basic assumptions. Write an interpretation of the results of your analysis.

Present your analysis as a 2-page report in a Word document formatted in APA style.

Receivables Management Case Study     A?© 2007 South University      
Down East Pharmaceuticals                
Select the appropriate input values and enter them in cells colored red. Once you do this, the base case solution will appear.
INPUT DATA:     KEY OUTPUT:          
Sales Forecasts:     Average Collection Period (Days):          
      End of March 39.6      
  Month Sales End of June 25.7      
  January $100,000            
  February 250,000 Receivables Balance:          
  March 400,000 End of March $330,000      
  April 600,000 End of June $300,000      
  May 450,000            
  June 300,000 Aging Schedules:          
        End of March End of June      
Assumed Collection Pattern:     0 – 30: 84.8% 70.0%      
      30 – 60: 15.2% 30.0%      
Month of sale 30.0% Over 60: 0.0% 0.0%      
One month after sale 50.0%            
Two months after sale 20.0% Payment Pattern:          
        End of March End of June      
      Total 90.0% 90.0%      
MODEL-GENERATED DATA:                
Calculation of Average     End of Month        
Collection Period (ACP):     March June        
Receivables balance   $330,000 $300,000        
Average daily sales   $8,333.33 $11,666.67        
ACP     39.6 25.7        
Aging Schedules:                
Age of                
Account End of March End of June        
in Days A/R % A/R %        
0-30 $280,000 84.8% $210,000 70.0%        
30-60 50,000 15.2% 90,000 30.0%        
60-90 0 0.0% 0 0.0%        
Total $330,000 100.0% $300,000 100.0%        
Uncollected Balances Schedules:                
End of March:                
      Accts Rec Remaining        
  Month Sales for month Rec/Sales        
  January $100,000 $0 0.0%        
  February 250,000 50,000 20.0%        
  March 400,000 280,000 70.0%        
    Total $330,000 90.0%        
End of June:                
      Accts Rec Remaining        
  Month Sales for month Rec/Sales        
  April $600,000 $0 0.0%        
  May 450,000 90,000 20.0%        
  June 300,000 210,000 70.0%        
    Total $300,000 90.0%        

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

At, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.

Professional Academic Writers

With, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.

Affordable Prices

Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.

On-Time delivery

My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.

100% Originality maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.

Customer Support 24/7

Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email:

Try it now!

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Homework Writing Services

My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.


Essay Writing Services

At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.


Admission and Business Papers

With, we will help you secure a position at your desired institution. Our essay writing services include the crafting of admissions papers. We will still help you climb your career ladder by helping you write the official papers that will help you secure a job. We will guide you on how to write an outstanding portfolio or resume.


Editing and Proofreading has a professional editorial team that will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper posses quality and originality.


Technical papers

My Homework Writers harbors professional academic writers from diverse academic disciplines. As such, we can develop homework writing services in all academic areas. The simplicity or complexity of the paper does not affect the quality of homework writing services.