logo

Balance Sheet Analysis Assignment

6 Pages1489 Words298 Views
   

Added on  2019-09-16

Balance Sheet Analysis Assignment

   Added on 2019-09-16

ShareRelated Documents
1PART I AND PART II OF THE ASSIGNMENT
Balance Sheet Analysis Assignment_1
2Table of ContentsPART I3PART II3-6
Balance Sheet Analysis Assignment_2
3PART I:Schedule 1 to Schedule 15, Please refer the “CapCo student excel template v2_Final.xlsx”Workbook.Note: The Balance Sheet Values given in the Solution does not match with the Actual Worked OutBalance Sheet for Schedule 12 to Schedule 14. Though the assumptions has been changed righlty.PART II:1.What percentage increase does this increase in selling price represent? Is it realistic to raiseprices this amount in a competitive market where Capco’s product is not differentiated? Answer: The selling price arrived at is $3,764 which is an increase of 3.12%. It is not realistic toraise prices in a competitive market.2.Based on his knowledge of the market, the owner is quite sure that the number of units soldcannot be increased unless the sales price is dropped. If the selling price was reduced by 2% to$3,577, he believes it is realistic to assume that projected monthly sales would increase salessubstantially from the current estimate of 2 additional units per month He is wondering by howmuch sales in units would have to increase each month at the lower selling price to earn$120,000 in net income (round your answer to one decimal point). Use GOAL SEEK todetermine whether this suggestion is viable if the company’s productioncapacity is a total of 750units for the year. Answer: This suggestion is not viable as the total units required to be sold to achieve Net Incomewould be 806 units which is higher than the production capacity of 750 units per year.3.Continuing on with scenario 2), by how much would net income increase if sales increased onlyto match production capacity at the new (lower) price? [Hint: you need to calculate how muchsales in units can increase each month at the lower selling price to arrive at the productioncapacity constraint of 750 units by using GOAL SEEK.] Answer: Existing Net Income of $70,473 would increase to $99,137 ie, $28,664 (40.67%increase of existing Net Income)4.Under the scenario outlined in 2) above, what is the credit line balance at the end of Decemberassuming there was no production constraint (i.e., you can produce as much as you need)?Explain why it has increased so dramatically even though net income has increased substantially(i.e., the company has become more profitable)? What do we learn about the current workingcapital policies of the company?
Balance Sheet Analysis Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
CapCo Financial Analysis
|6
|1489
|172

Projected Level of Income and the Fact
|5
|1575
|197

Financial Management: Solved Questions and Answers
|7
|1477
|263

Financial Statement Analysis
|6
|964
|88

ACC202 Management Accounting Assignment
|3
|845
|120

Management Accounting: Techniques and Importance in Decision Making
|13
|2628
|238