Examlex

Solved

Use the Following Information and the Percent-Of-Sales Method to Answer

question 54

Multiple Choice

Use the following information and the percent-of-sales method to answer the following question(s) .
Below is the 2014 year-end balance sheet for Banner,Inc.Sales for 2014 were $1,600,000 and are expected to be $2,000,000 during 2015.In addition,we know that Banner plans to pay $90,000 in 2015 dividends and expects projected net income of 4% of sales.(For consistency with the Answer selections provided,round your forecast percentages to two decimals. )
Banner,Inc.Balance Sheet
December 31,2014
Assets
Current assets $890,000
Net fixed assets 1,000,000
Total $1,890,000
Liabilities and Owners' Equity
Accounts payable $160,000
Accrued expenses 100,000
Notes payable 700,000
Long-term debt 300,000
Total liabilities 1,260,000
Common stock (plus paid-in capital) 360,000
Retained earnings 270,000
Common equity 630,000
Total 1,890,000
-Banner's projected retained earnings for 2015 are

Utilize Excel's filtering and lookup functions for data analysis.
Techniques for making Excel tables accessible and printable.
Employ Excel formulas and functions for data manipulation and retrieval.
Understand the concept of correlation coefficient within the context of market pay lines.

Definitions:

Assessment/Diagnosis

The process of evaluating the nature and cause of a health condition based on symptoms, tests, and other data.

Clinical Decision Support

A health information technology system that provides clinicians, staff, and patients with knowledge and person-specific information, intelligently filtered and presented at appropriate times, to enhance health and healthcare.

Specialty

A particular branch of medicine or surgery in which a doctor has undergone advanced training and gained expertise.

Objective Finding

A measurable or observable fact or symptom in a patient, discernible through diagnostic tests or physical examination.

Related Questions