Cynthia Valley formed Out-West Products, Inc. (OWP) in 2020 when…

Cynthia Valley formed Out-West Products, Inc. (OWP) in 2020 when she obtained an exclusive franchise to nationally distribute a pen-based input device that provides effortless communication with standard personal computers.  Recent high sales growth of the base model pen-based input device (PID-B), along with expected sales growth for a new premium model (PID-P), requires adding new management team members.  The Company hires you as a management trainee to assume direct responsibility for financial planning activities.  Your first assignment is to prepare a financial plan for the next three months, starting July 1.

 

CASH COLLECTION PATTERN is as follows:

 

30% of a month’s sales are collected by month-end.  An additional 40% is collected in the month following, and the remaining 30% is collected in the second month following sale.  Thus far bad debts have been negligible. 

 

Since OWP’s policy is to never stock out of its pen-based input devices (PIDs), and potentially forfeit market share to competitors, the Company maintains fairly high inventory levels.

 

Therefore, desired ending inventories are equal to 70% of the next month’s sales in units. 

 

Prior to June, OWP sold only the basic model PID-B at a price of $230 per unit.  The PID-B costs OutWest Products $155 each from the manufacturer and it pays for purchases as follows:

 

CASH Disbursements PATTERN is as follows:

 

60% in the month of purchase and the remaining 40% the following month.   

 

The company’s monthly operating expenses (organized by cost behavior) are also provided in the Assumptions Sheet of the excel template.  All operating expenses are paid during the month, in cash, with the exception of depreciation and insurance expenses.

 

New fixed assets, including personal computers and office furniture, will be purchased during September for $90,000 cash. Ignore depreciation for these newly acquired since they are insignificant.  The Company declares dividends of $20,000 each quarter, payable in the first month of the following quarter.

 

OWP’s actual balance sheet at June 30, 2020 is provided at the end of the template’s Assumptions Sheet.

 

 

However, the Company also desires a minimum ending cash balance each month of $35,000 to meet regular operating expenses.  Assume borrowings occur at the beginning of the period. To further simplify, assume no tax consequences.

 

 

REQUIRED: 

 

 

Financial Planning Model

Download the Excel template from your Blackboard course page – DO NOT MODIFY THE FORMAT OF THE TEMPLATE.  Save the file and do not attempt to complete the template directly from the course page and do not copy and paste sheets into a new workbook. Case assumptions have already been provided in the template’s assumptions sheet.  If necessary, it may be helpful to review Chapter 3 (CVP Analysis) and Chapter 6 (Budgeting) in your textbook prior to beginning the project. Be sure to regularly save your work as you complete the model.  Remember that you must use formulas so that any changes in input data automatically update your model.  Otherwise, your model will not work adequately and you will lose points. First, complete the sheets of the Excel template, as indicated below. 

 

 

Complete Sheet 4 (Statements of Cash Flow) 

  1. Projected statements of cash by month and in total – internal budget format. 

 

Graph 

Use the data in the Graph worksheet to create a cost-volume-profit graph.

Highlight the cells A13:H16. Click insert and Select a line chart type for the CVP graph (your choice of style).

Be sure that your graph closely resembles a standard CVP graph or points will not be awarded

How to Get Help with your Assignment in 3 mins

  1. Place Your Assignment Request in under 3 mins

    To access our online order form, click the "Order Now" button below.
  2. Complete the Payment

    Click on checkout link at the bottom of the order page to pay.
  3. Download Your Assignment

    Once we receive payment, one of our highly qualified essay writing experts will work on your assignment and complete it within your selected deadline.

What does the completed assignment have?

  • Thorough Research and High-Quality Essay Writing
  • Native UK, US, Canadian, Australian Writers
  • Up-to-date Sources Only (Less than 5 years)
  • 24/7 Online Support
  • Essay in 1,3, 6, 8, 12, 16, 20 hours +...!
  • 100% Plagiarism Free
  • 100% Privacy Guarantee
  • Times New Roman, 12pt
  • Any Referencing Styles (APA, MLA, Harvard, Chicago, Turabian...)
  • 275+ Words per page
  • Single/Double Spaced Papers
  • Plagiarism Report on Request

Why do college students choose our assignment help service?

  • list icon instant gradesExcellent Grades Guaranteed! (A+ or B Minimum)
  • list icon instant grades Privacy Guarantee - No one will ever know!
  • list icon instant gradesAlways delivered on time
  • list icon instant grades High-Quality Essays
  • list icon instant grades24/7 Instant Online Support
  • list icon instant gradesTitle Page --- FREE!
  • list icon instant gradesTable of Contents --- FREE!
  • list icon instant gradesReferences List ---FREE!
  • list icon instant gradesRevisions---FREE!
  • list icon instant gradesPlagiarism Report ---FREE!
  • list icon instant gradesEditing before submitting it to you ---FREE!