Reference no: EM131123574
Artero Corporation is a traditional toy products retailer that recently started an Internet-based subsidiary that sells toys online. A markup is added on goods the company purchases from manufacturers for resale. Swen Artero, the company president, is preparing for a meeting with Jennifer Brown, a loan officer with First Banco Corporation, to review year-end financing requirements. After discussions with the company's marketing manager, Rolf Eriksson, and finance manager, Lisa Erdinger, sales over the last three months of 2011 are forecasted to be:
SALES FORECAST
MONTH (IN $ THOUSANDS)
October 2011 ....... $1,000
November ........ 1,500
December ........ 3,000
Artero's balance sheet as of the end of September 2011 was as follows:
All sales are made on credit terms of net 30 days and are collected the following month. No bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October, the October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or safety stock), which the company intends to maintain. Cost of goods sold averages 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales.
Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes.
The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12 percent. There are no capital expenditures planned during the period, and no dividends will be paid. The company's desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during the period by increasing the firm's notes payable to the bank. The interest rate on new loans will be 12 percent.
A. Prepare monthly pro forma income statements for October, November, and December and for the quarter ending December 31, 2011.
B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2011.
C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, November, and December 2011.
D. Describe your findings and indicate the maximum amount of bank borrowing that is needed.
|
Identify one type of information that is typically given
: Identify one type of information that is typically given an approximate digital representation. Briefly explain why this is the case. What are the common approximations, and how close are they? In what situations is this approximation a problem?
|
|
Educational psychology serves as the bridge
: Educational psychology serves as the bridge between theory and practice in our classrooms. Best practices in the classroom stem from the research and developed theories about how we learn and behave which is the driving force that guides how we te..
|
|
What is the present value of mary''s project
: What is the present value of Mary's project?
|
|
Evaluate the values of function of the equations
: Please solve te following equation Q1.) Find ∫ x ln(x) dx
|
|
Indicate the maximum amount of bank borrowing that is needed
: A. Prepare monthly pro forma income statements for October, November, and December and for the quarter ending December 31, 2011. B. Prepare monthly pro forma balance sheets at the end of October, November, and December 2011. C. Prepare both a monthly..
|
|
Why would an organization create such a policy or practice
: List three human resources management (HRM) policies or practices that have ethical implications and require greater consideration. One example is employee monitoring (e.g., whether employees are wasting time surfing the Internet on company time).
|
|
Cognitive development learning theories
: Have you ever wondered how students learn? Well, there are many learning theorists that have proposed the process in which one acquires new knowledge and each one significantly contributes to the process of cognitive development.
|
|
Create a data model for on adult baseball league
: Create a data model for on Adult Baseball league which supports all of the following data requirements. Create an example model of this relationship using the MySQL Workbench data modeler.
|
|
Define research method employed in reviewe empirical studies
: Describe the contributions of this research to the issues discussed and critically evaluates these contributions. If possible identify gaps in the literature on this topic within leaders, influence, and power.
|