Q1) New Robotic Corporation has net sales of $743,000 at the end of 2013. During
ID: 2781710 • Letter: Q
Question
Q1) New Robotic Corporation has net sales of $743,000 at the end of 2013. During this period, cost of good sold (COGS) is $443,000 and depreciation is $15,200. Interest paid by New Robotic in 2013 is 9% debt. Finally, effective corporate tax rate for New Robotic Corporation is 35%. Following is the Balance Sheet of Robotic 2013 and 2012 respectively CXV Corporation 2013 2012 2013 2012 Cash Accounts Receivable Inventory Total Net Fixed Assets $20,240 $15,400 Accounts Payable $54,400 $45,000 $13,600 $20,000 $68,000 $65,000 $122,320 $116,100 Long-term Debt $126,000 $150,000 $330,400 $267,621 Common Stock $112,000 $112,000 Retained Earnings $146,720 $56,721 $258,720 $168,721 $32,560 $69,520 $70,500 Total $30,200 Notes Payable Total Total Assets $452,720 $383,721 Total Liab. & Equity $452,720 $383,721 a) What is the NI of New Robotic Corporation in 2013? (10pts)Explanation / Answer
Answer :
Answering the first question and its parts. please post rest of the questions separately to get answers, allowed to answer the first part only
Sales in 2013 : $743000
COGS: $443000
Depreciation: $15200
Tax : Subtract Depreciation and interest and apply 35% to tax amount
Net income : Sales - COGS - Depreciation - Interest - tax to be paid
Net income : 743000- 443000- 15200- (126000*0.09)- 95711
Net Income : $177749
Assumption: Selling, general and administrative cost have been taken 0 as it is not given here.
B) Free cah flow formula: it is defined as the cash company generated after spending the money required to maintain or expand its assets required for the business expansion
EBIT (1-tax rate) + (depreciation) + (amortization) - (change in net working capital) - (capital expenditure during the year)
EBIT is sales - COGS = 743000-443000 = 300000
Tax rate = 35%
Dep : 15200
Amortization = 0 here
change in wroking capital :
Working capital is defined as
current assets - current liabilities
IN 2012 CA value was $116100 and CL value was 65000 So, Working capital was 51100
Similarly in 2013 working capital was 54320
Change in working capital 2013-2012 values
$54320 - $51100= $3220
Capital expenditure : change in fixed asset value from 2012 to 2013
$330400-$267621= $62779
Putting these values will give
Free cash flow = 300000(1-0.35) +15200+0 - 3220-62779
= 195000+15200-3220-62779
=$144201
Answering part 3
Will use the discounted cash flow method to calculate the value of the company and then divide by no of shares to calculate the stock price.
Formula used have been mentioned along
Divide total valuation by no of shares
5583245/100000 = 55.83245 share price
Discount rate 8% Present value formula cash flow/(1 + interest rate)^ ( no of years) 0 1 2 3 2013 2014 2015 2016 FCF 144201 158621.1 174483.2 191931.5 Present value of cash flows 144201 146871.3889 149591.2 152361.4 terminal value(2017 and above) 4990220 fcf last year( 1 + terminal growth rate)/( discount rate- growth rate) total valuation 5583245Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.