Question and Problem Sets

User Generated

Wvuna23

Business Finance

Description

Purpose of Assignment

Provide students with a basic understanding of financial management, goal of the firm, and the basic financial statements. Students should be able to calculate and analyze solvency, liquidity, profitability and market value ratios, and create proforma financial statements.

Assignment Steps

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web that offer support for office products.

Complete the following Questions and Problems (Concepts and Critical Thinking Questions for Ch. 1 Only) from each chapter as indicated.

Show all work and analysis.

Prepare in Microsoft® Excel® or Word.

  • Ch. 1: Questions 3 & 11 (Concepts Review and Critical Thinking Questions section)
  • Ch. 2: Questions 4 & 9 (Questions and Problems section): Microsoft® Excel® template provided for Problem 4.
  • Ch. 3: Questions 4 & 7 (Question and Problems section)
  • Ch. 4: Questions 1 & 6 (Questions and Problems section): Microsoft® Excel® template provided for Problem 6.

Format your assignment consistent with APA guidelines if submitting in Microsoft® Word.


Unformatted Attachment Preview

Chapter 2 Problems 2, 3, 4, 6, 7, 14, 15, 19 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." Chapter 2 Question 4 Input area: Sales Costs Depreciation expense Interest expense Tax rate Cash dividends Shares outstanding Output area: Income Statement $ Sales Costs Depreciation expense EBIT Interest expense EBT Taxes (0%) Net income Addition to retained earnings - $ $ - $ - $ - Earnings per share #DIV/0! Dividends per share #DIV/0! Chapter 4 Problems 5, 6, 20, 22 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." Chapter 4 Question 6 Input area: Sales Costs Taxable income Taxes Net income $ Current assets Fixed assets Total - $ - Payout ratio Tax rate Output area: Return on assets Retention ratio Internal growth rate #DIV/0! 100% #DIV/0! $ Debt Equity - Total $ -
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

#3
The primary disadvantage of a corporation as a form of business is that there is double taxation. This is
taxation to shareholders of distributed earnings and dividends. The advantage of this type of business
is that it has an unlimited liability, ease of transferability of ownership and unlimited useful life.

#11
The current stock gives the managers an hint to long term and short term risks, period ans the size of
cah flow. Therefore managers should focus on the current stock value which hmakes the above
statement incorrect.

#4
Ending inventory
Cost of goods sold

$417,381
$4,682,715

Inventory turnover
Cost of goods sold/ inventory

11.22

Days of sale...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags