Financial Statement

User Generated


Business Finance


Construct a balance sheet and comment on liquidity

Unformatted Attachment Preview

Foundations of Business Finance, BUS 860 Assignment #3 Assignment Purpose: to apply core concepts learnt from Foundations of Business Finance in a culminating assignment. Assignment Objective: to apply your understanding for analyzing, interpreting and creating financial statements including financial ratio and breakeven analysis. Textbook Chapters/Resources for Reference: chapters 1-10 (Bergeron). Deliverable Format: in Microsoft Word or PDF-copy. If you use Microsoft Excel, please copy and paste it into Microsoft Word or PDF. Please submit your assignment only in one file copy and do not submit multiple formats or copies. 1. (20 Marks) Required: a) Construct a balance sheet out of the following information. This is like a puzzle where you have to put the pieces in the correct place. You have to identify the accounts below as to whether they are an asset or a liability. Remember that the balance sheet needs to balance on both sides. Try to make it look like a proper balance sheet with the heading, sections, etc. (10 marks) b) Comment on the liquidity of the Redpart Company based on the balance sheet information given. Please substantiate your responses with relevant financial ratios. (5 marks) c) If you were a bank, would you lend money to this company? Why or why not? Please substantiate your responses with relevant financial ratios. (5 marks) Redpart Company Balance Sheet as at November 30, 2016 Cash Bank Loan Accounts Receivable Prepaid Insurance Accounts Payable Building Truck Accumulated Depreciation Owner’s Equity $2,000 $36,000 $5,000 $1,000 $21,000 $125,000 $20,000 $23,000 ???? 1 2. (21 Marks) Blanchard Co. manufactures tires for sale to distributors for an average price of $65 each. The variable costs of each tire are $43 and the monthly fixed manufacturing costs total $64,000. Required: a) What is the breakeven point? (5 marks) b) What is the breakeven point, in tires, assuming variable costs increase by 20 per cent? (5 marks) c) What do you believe is the maximum price that Blanchard Co can charge for its tire? Please substantiate your responses with relevant financial ratios. (5 marks) d) Suggest 3 other additional potential accounting items that would be potential fixed costs to Blanchard’s business. (6 marks) 3. (10 marks) Required: With the below financial information for a company for fiscal year 2016, create a budget for fiscal year 2017 assuming a growth rate of 5%/annum. Revenues Cost of Goods Sold Gross Profit Sales & General Expenses Salaries Expense Interest Expense Research & Development Expense Operating Income Taxes (20%) Net Income $100,000 12,000 88,000 3,000 2,000 1,000 5,000 77,000 15,400 $ 61,600 4. Why is the cost of capital important for an organization? Please list and explain three key criteria that you would recommend to help a company determine the optimal capital structure. (10 marks) 5. How can Present Value calculations help a company ensure that it selects the projects or investments that will generate the highest level of investment return taking into consideration Internal Rate of Return (IRR)? Is there a difference Present Value and Net Present Value? Please explain why. (5 ma 2
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

Hello there, kindly find attached

Financial statement analysis

Financial statement analysis

Student name

Instructor’s name


Financial statement analysis

1. Balance sheet

Financial statement of Redpart
Redpart Company
Statement of financial position
As at 30th November 2016
Current assets





Account’s receivables


Prepaid insurance


Total current assets


Fixed assets
Building at cost
Less: Accumulated depreciation





Total fixed assets


Total assets


Current liabilities
Bank loan


Accounts payable


Total current liabilities


Owners’ equity

Financial statement analysis
Total assets less total liabilities (130,000.000-57,000.00)


Total liabilities + Owners equity



Liquidity position of the company

Current ratio=Current assets/Current liabilities
Current assets $8,000.00, Current liabilities $57,000.00
Current ratio (8000/57000) =0.14

Acid test/Quick ratio= current assets/Current liabilities (8,000/57,000) = 0.14

Working capital- Current assets-Current liabilities

(8000.00-57,000.00)= (49,000.00)
• Debt-equity ratio= Total liabilities/Total equity
Total liabilities 57,000
Owner’s equity 73,000
Debt-equity ratio (57,000/73,000) =0.78
The company current ratio was 0.14 which implies that the current assets of Redpart are not
adequately enough to safeguard the firm’s short-term obligations. The current ratio of 0.14 is less than 1
which implies the business is unable to meet its short-term obligations. The busi...

Really great stuff, couldn't ask for more.


Related Tags