In: Advanced Math
On January 1, 20X8, Parent Company purchased 75% of the common stock of Subsidiary Company for $360,000. On this date, Subsidiary had common stock, other paid in capital, and retained earnings of $20,000, $130,000, and $200,000, respectively. Any excess of cost over book value is due to goodwill. Parent accounts for the Investment in Subsidiary using cost method. On January 1, 20X8, Subsidiary sold $100,000 par value of 6%, ten-year bonds for $97,000. The bonds pay interest semi-annually on January 1 and July 1 of each year. On January 1, 20X9, Parent repurchased all of Subsidiary's bonds for $99,100. The bonds are still held on December 31, 20X9. Both companies have correctly recorded all entries relative to bonds and interest, using straight-line amortization for premium or discount. Calculate NCI's portion of consolidated net income for the year ended of December 31, 20X9. Round all computations to the nearest dollar
Please like if u helps you ?
To solve
this question just input those variables which are to be used in
logistic regression, as the question talks about using two
variables only that is total loans and leases to total assets &
total expenses/ total assets, so we will not input total cap/assets
as an input variable in our excel, here we go
As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table
1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2
2. Calculate exponential of logit in the next column by using exp (value in previous column)
3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column
4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)
5. take the total of the column values of log likelihood
6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2
which comes out to be b0=-14.72, b1=89.83, b2= 8.37
therefore you will get logit as
-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets
With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get
logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833
exp (logit) = 1.20
Probability= 0.546
Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605