assignment
Assignment question Student #11800287Step 1:Select your student number from the drop down list 9781900044100 BhuwanBHATTStep 2:Check your Name to ensure you have selected your student number correctly%ConsiderationProfit Important: The file should be opened in ExcelStep 3:Find your following assignment question and follow the directions . Step 4:Prepare your assignment in Microsoft Word. Step 5:Upload your assignment in Moodle before the due date. The assignment must be typed, use Arial font, 12, to avoid plagiarism, make sure you do proper referencing, a WORD format file soft copy to be submitted in Moodle before the due date. Please ensure you provide your ID numbers and full name at the first page. Late assignments will be penalised, 5%of total available marks deduction per day. Assignment Question Nina Ltd purchased 97% of the issued shares of Carl Ltd for $819000 on 1 July 2018 when the equity of Carl Ltd was as follows; Share capital327600 Retained earnings245700 General reserve122850696150 At this date, Carl Ltd had not recorded any goodwill, and all identifiable assets and liabilities were recorded at fair value except for the followings; AccountCostCarrying AmountFair valueFurther life(Years) Inventories$24,600$27,100 Land$61,000$67,000 Furniture$95,000$76,000$91,0004 Carl Ltd identified at acquisition date a contingent liability related to a lawsuit where Carl Ltd was sued by a former supplier$10,000 Carl Ltd had unrecorded and internally generated Patent with the FairValue of:$25,000 Carl Ltd had unrecorded and internally generated in-process research and development with the FairValue of:$19,000 60% of inventory on hand at 1 July 2018 were sold by 30 June 2019. Further life of the assets are listed on the above table. Partial goodwill method is under use and Tax rate:30% Required 1- Prepare the acquisition analysis at acquisition date. 2- Prepare the business combination valuation entries and pre-acquisition entry at acquisition date. 3- Prepare the journal entry to recognise NCI at acquisition date. 4-Prepare the consolidation worksheet entries at 30 June 2019. Assume a profit for Carl Ltd for the year ended 30 June 2019 of $44100. 5- Explain how the step 1 to 4 will change if the full goodwill method is used. 6. List and explain the accounting standards issues relevant to the consolidation process. 7. Compare in detail the current situation with the case that Nina Ltd acquires only 20% of issued shares of Carl Ltd with a significant influence on Carl Ltd. 6 17 49 5 57 99 84 17 Instruction Student #11800287Step 1:Enter your student number Step 2:Have a look to Customer Database sheet 92Step 3:Read Yellow Cells Directions for Red sheets 38Step 4:Complete and calculate the pink cells 84 37 66 27 17 49 66 17 5 12 71 5 3 27 99 3 99 49 12 12 49 84 6 71 92 99 27 6 38 27 38 92 3 84 5 5 57 3 66 5 71 38 66 57 6 5 71 57 12 5 6 17 49 5 57 99 84 17 Customers database % First nameSurnameID numberProfitConsiderationAsset 1Asset 2Asset 3Asset 1-CAAsset 2-CAAsset 3-CAAsset 3 costAsset 3 Acc-DepAsset 4 CAAsset 4 CostAsset 3 LifeAsset 1-FVAsset 2-FVAsset 3-FVAsset 4-FVControl%NCIAsset 1-DiffAsset 2-DiffAsset 3-DiffAsset 1-BCVRAsset 2-BCVRAsset 3-BCVRAsset 4-BCVRLiB FV-BCVREquity 1-Nameequity 2-Nameequity 3-NameEquity 1Equity 2Equity 3Total EquityFVINANCI in DavisAggregate GoodwillProfit Malik Adnan HussainBHATTI1160040518000922000InventoriesLand Machinery 138,000277,000323,000388,00065,00013,25014,8755248,000499,000581,00016,500901011000022200025800077000155400180600227535000Share capitalRetained earningsGeneral reserve323,000138,000111,00057200095227595228101722864953- 104,220 SushmaTAMANG THAPA11601169490002450000InventoriesLand Plant368,000735,000858,0001,030,000172,00036,25039,37510662,0001,323,0001,544,00042,500919294000588000686000205800411600480200437535000Share capitalGeneral reserveAsset revaluation surpluss858,000368,000294,00015200002586975232828268282895853- 216,860 SanjogK C11700775330001662000InventoriesLand Equipment 249,000499,000582,000698,000116,00024,35026,5254448,000898,0001,048,00028,700928199000399000466000139300279300326200304535000Share capitalAsset revaluation surplussRetained earnings582,000249,000199,00010300001742845139428180142858583- 208,150 PraptiBHATTARAI11701033440002178000InventoriesLand Furniture327,000653,000762,000914,000152,00032,15033,2258589,0001,175,0001,372,00034,3009010262000522000610000183400365400427000150535000Share capitalRetained earningsGeneral reserve762,000327,000261,000135000022923052292312407231114926- 206,075 AkashdeepSINGH11701037440002186000InventoriesLand Vehicle 328,000656,000765,000918,000153,00032,25033,3755590,0001,181,0001,377,00034,500919262000525000612000183400367500428400157535000Share capitalGeneral reserveAsset revaluation surpluss765,000328,000262,00013550002300875207079239307992204- 246,500 Simran Kaur--11701254520002620000InventoriesLand Machinery 393,000786,000917,0001,100,000183,00038,75043,12510707,0001,415,0001,651,00047,500928314000629000734000219800440300513800612535000Share capitalAsset revaluation surplussRetained earnings917,000393,000314,00016240002769025221522284152272497- 231,990 SandeshKHADKA11701310550002732000InventoriesLand Plant410,000820,000956,0001,147,000191,00040,45040,6754738,0001,476,0001,721,00040,900901032800065600076500022960045920053550031535000Share capitalRetained earningsGeneral reserve956,000410,000328,000169400028836152883623020362136747- 341,900 RabinUPRETY11701549640003210000InventoriesLand Equipment 482,000963,0001,124,0001,349,000225,00047,65051,4758868,0001,733,0002,023,00055,300919386000770000899000270200539000629300535535000Share capitalGeneral reserveAsset revaluation surpluss1,124,000482,000385,000199100033998553059873515987116132- 304,550 SubashBANJARA11701609670003330000InventoriesLand Furniture500,000999,0001,166,0001,399,000233,00049,45054,1755900,0001,798,0002,099,00058,900928400000799000933000280000559300653100661535000Share capitalAsset revaluation surplussRetained earnings1,166,000500,000400,00020660003530015282401361240182386- 376,240 UsmanTARIQ11701844760003800000InventoriesLand Vehicle 570,0001,140,0001,330,0001,596,000266,00056,45059,675101,026,0002,052,0002,394,00062,90090104560009120001064000319200638400744800451535000Share capitalRetained earningsGeneral reserve1,330,000570,000456,000235600040279154027924202792174877- 336,300 FaizaNISAR118000203000152000InventoriesLand Machinery 23,00046,00053,00064,00011,0001,7502,625441,00083,00095,0003,500919180003700042000126002590029400122535000Share capitalGeneral reserveAsset revaluation surpluss53,00023,00018,000940001281251153116353135406- 18,875 MohammadALAUDDIN118000494000210000InventoriesLand Plant32,00063,00074,00089,00015,0002,6503,975858,000113,000133,0005,300928260005000059000182003500041300185535000Share capitalAsset revaluation surplussRetained earnings74,00032,00025,0001310001923551538822538833033- 20,675 DipakPOKHAREL118000805000272000InventoriesLand Equipment 41,00082,00095,000114,00019,0003,5505,325574,000148,000171,0007,1009010330006600076000231004620053200248535000Share capitalRetained earningsGeneral reserve95,00041,00033,0001690002589852589929789938914- 31,400 SabinKHADKA118001097000330000InventoriesLand Furniture50,00099,000116,000139,00023,0004,4506,6751090,000178,000209,0008,900919400007900093000280005530065100311535000Share capitalGeneral reserveAsset revaluation surpluss116,00050,00040,0002060003225152902635902636511- 29,120 NiteshSUBEDI118001117000334000InventoriesLand Vehicle 50,000100,000117,000140,00023,0004,4506,675490,000180,000211,0008,900928400008000094000280005600065800311535000Share capitalAsset revaluation surplussRetained earnings117,00050,00040,0002070003249152599335999335078- 41,475 Shishir KumarATAL118001468000404000InventoriesLand Machinery 61,000121,000141,000169,00028,0005,5508,3258110,000218,000254,00011,10090104900097000113000343006790079100388535000Share capitalRetained earningsGeneral reserve141,00061,00048,0002500004001854001944401943834- 38,638 SandipPOUDEL1180021411000540000InventoriesLand Plant81,000162,000189,000227,00038,0007,55011,3255146,000292,000340,00015,100919650001300001510004550091000105700528535000Share capitalGeneral reserveAsset revaluation surpluss189,00081,00065,0003350005474854927458927441789- 60,960 AnishSEDHAI1180021511000542000InventoriesLand Equipment 81,000163,000190,000228,00038,0007,55011,32510146,000293,000342,00015,100928650001300001520004550091000106400528535000Share capitalAsset revaluation surplussRetained earnings190,00081,00065,0003360005491854393558593536750- 47,800 BhuwanBHATT1180028714000686000InventoriesLand Furniture103,000206,000240,000288,00048,0009,75014,6254185,000371,000432,00019,50090108200016500019200057400115500134400682535000Share capitalRetained earningsGeneral reserve240,000103,00082,0004250007041257041375641352288- 85,400 AakashGAIRE1180030014000712000InventoriesLand Vehicle 107,000214,000249,000299,00050,00010,15010,2258193,000385,000448,00010,300919860001710001990006020011970013930010535000Share capitalGeneral reserveAsset revaluation surpluss249,000107,00085,0004410007253056527777727751972- 67,988 Sudikshya PratapeswariRANA1180031215000736000InventoriesLand Machinery 110,000221,000258,000310,00052,00010,45010,6755198,000398,000464,00010,900928880001770002060006160012390014420031535000Share capitalAsset revaluation surplussRetained earnings258,000110,00088,0004560007510156008179608145066- 82,720 SujanKAFLE1180031715000746000InventoriesLand Plant112,000224,000261,000313,00052,00010,65010,97510202,000403,000470,00011,3009010900001790002090006300012530014630045535000Share capitalRetained earningsGeneral reserve261,000112,00090,0004630007630557630682230659251- 66,270 SrijanaGURUNG1180034316000798000InventoriesLand Equipment 120,000239,000279,000335,00056,00011,45012,1754216,000430,000502,00012,9009199600019100022300067200133700156100101535000Share capitalGeneral reserveAsset revaluation surpluss279,000120,00096,0004950008180157362187162153606- 100,025 AnantaGURUNG1180035316000818000InventoriesLand Furniture123,000245,000286,000343,00057,00011,75012,6258221,000441,000515,00013,5009289800019600022900068600137200160300122535000Share capitalAsset revaluation surplussRetained earnings286,000123,00098,0005070008393256714688514645821- 77,625 SujanPATHAK1180040518000922000InventoriesLand Vehicle 138,000277,000323,000388,00065,00013,25014,8755248,000499,000581,00016,500901011000022200025800077000155400180600227535000Share capitalRetained earningsGeneral reserve323,000138,000111,00057200095227595228101722864953- 104,220 SarojDANUWAR1180041319000938000InventoriesLand Machinery 141,000281,000328,000394,00066,00013,55015,32510254,000506,000590,00017,10091911300022500026200079100157500183400248535000Share capitalGeneral reserveAsset revaluation surpluss328,000141,000113,00058200096948587254102525455769- 83,060 AvidhSHRESTHA11800476210001064000InventoriesLand Plant160,000319,000372,000446,00074,00015,45018,1754288,000574,000670,00020,90092812800025500029800089600178500208600381535000Share capitalAsset revaluation surplussRetained earnings372,000160,000128,000660000110551588441115244146926- 133,700 PraptiBUDHATHOKI11800487220001086000InventoriesLand Equipment 163,000326,000380,000456,00076,00015,75018,6258293,000587,000684,00021,500901013000026100030400091000182700212800402535000Share capitalRetained earningsGeneral reserve380,000163,000130,0006730001128525112853119885370328- 102,250 ManishGIRI11800500220001112000InventoriesLand Furniture167,000334,000389,000467,00078,00016,15019,2255301,000601,000700,00022,30091913400026700031100093800186900217700430535000Share capitalGeneral reserveAsset revaluation surpluss389,000167,000133,0006890001156705104103121610359398- 126,260 DikshyaBUDHATHOKI11800632280001376000InventoriesLand Vehicle 206,000413,000482,000578,00096,00020,05020,07510371,000743,000868,00020,1009281650003300003860001155002310002702003535000Share capitalAsset revaluation surplussRetained earnings482,000206,000165,0008530001434735114779149077956044- 121,240 Muhammad JamalMEHDI11800725310001562000InventoriesLand Machinery 234,000469,000547,000656,000109,00022,85024,2754421,000844,000985,00025,7009010187000375000438000130900262500306600199535000Share capitalRetained earningsGeneral reserve547,000234,000187,0009680001634995163500172550090505- 195,625 PradipSAPKOTA11800801340001714000InventoriesLand Plant257,000514,000600,000720,000120,00025,15027,7258463,000925,0001,080,00030,300919206000411000480000144200287700336000360535000Share capitalGeneral reserveAsset revaluation surpluss600,000257,000206,00010630001799505161955187595576450- 162,700 RuhinaTHAPA MAGAR11800810350001732000InventoriesLand Equipment 260,000520,000606,000727,000121,00025,45028,1755468,000936,0001,091,00030,900928208000416000485000145600291200339500381535000Share capitalAsset revaluation surplussRetained earnings606,000260,000208,00010740001819115145529187752958414- 195,440 GopalBARAL11800812350001736000InventoriesLand Furniture260,000521,000608,000730,000122,00025,45028,17510468,000938,0001,094,00030,9009010208000417000486000145600291900340200381535000Share capitalRetained earningsGeneral reserve608,000260,000208,00010760001822515182252191825295737- 153,160 TulsiSHRESTHA11800813350001738000InventoriesLand Vehicle 261,000521,000608,000730,000122,00025,55028,3254470,000938,0001,094,00031,100919209000417000486000146300291900340200388535000Share capitalGeneral reserveAsset revaluation surpluss608,000261,000209,00010780001825285164276190227676991- 217,700 NishaSHRESTHA KARMACHARYA11800836360001784000InventoriesLand Machinery 268,000535,000624,000749,000125,00026,25029,3758482,000963,0001,123,00032,500928214000428000499000149800299600349300437535000Share capitalAsset revaluation surplussRetained earnings624,000268,000214,00011060001874075149926193392659851- 168,400 Maricel GalloBERNADAS11800846360001804000InventoriesLand Plant271,000541,000631,000757,000126,00026,55029,8255488,000974,0001,136,00033,1009010217000433000505000151900303100353500458535000Share capitalRetained earningsGeneral reserve631,000271,000216,00011180001896085189609199360997524- 204,240 NishaRAWAL11800926390001964000InventoriesLand Equipment 295,000589,000687,000824,000137,00028,95033,42510531,0001,060,0001,237,00037,900919236000471000550000165200329700385000626535000Share capitalGeneral reserveAsset revaluation surpluss687,000295,000236,00012180002069165186225215022581060- 174,290 SworupSHRESTHA KANDEU11800942400001996000InventoriesLand Furniture299,000599,000699,000839,000140,00029,35034,0254538,0001,078,0001,258,00038,700928239000479000559000167300335300391300654535000Share capitalAsset revaluation surplussRetained earnings699,000299,000240,00012380002103445168276216427660831- 249,625 Pinky RajeshkumarHARIRAMANI11800951400002014000InventoriesLand Vehicle 302,000604,000705,000846,000141,00029,65034,4758544,0001,087,0001,269,00039,3009010242000483000564000169400338100394800675535000Share capitalRetained earningsGeneral reserve705,000302,000242,000124900021230552123062226306103251- 191,088 ZigarMAHARJAN11800990420002092000InventoriesLand Machinery 314,000628,000732,000878,000146,00030,85031,2755565,0001,130,0001,318,00031,70091925100050200058600017570035140041020059535000Share capitalGeneral reserveAsset revaluation surpluss732,000314,000251,00012970002199895197991228999190096- 236,180 KishorBIST11801019430002150000InventoriesLand Plant323,000645,000753,000904,000151,00031,75032,62510581,0001,161,0001,355,00033,500928258000516000602000180600361200421400122535000Share capitalAsset revaluation surplussRetained earnings753,000323,000258,00013340002263425181074233107467649- 190,310 SujitDISHA11801103460002318000InventoriesLand Equipment 348,000695,000811,000973,000162,00034,25036,3754626,0001,251,0001,460,00038,5009010278000556000649000194600389200454300297535000Share capitalRetained earningsGeneral reserve811,000348,000278,000143700024430752443082562308119233- 290,525 AnishSILWAL11801107470002326000InventoriesLand Furniture349,000698,000814,000977,000163,00034,35036,5258628,0001,256,0001,465,00038,700919279000558000651000195300390600455700304535000Share capitalGeneral reserveAsset revaluation surpluss814,000349,000279,00014420002451645220648254664895003- 219,525 SonikaBALAMI11801152480002416000InventoriesLand Vehicle 362,000725,000846,0001,015,000169,00035,65038,4755652,0001,305,0001,523,00041,300928290000580000677000203000406000473900395535000Share capitalAsset revaluation surplussRetained earnings846,000362,000290,00014980002549855203988261998870133- 273,440 AjitBOMJAN11801156480002424000InventoriesLand Machinery 364,000727,000848,0001,018,000170,00035,85038,77510655,0001,309,0001,526,00041,7009010291000582000678000203700407400474600409535000Share capitalRetained earningsGeneral reserve848,000364,000291,000150300025577952557802679780121985- 215,060 AnishGARTAULA11801220510002552000InventoriesLand Plant383,000766,000893,0001,072,000179,00037,75041,6254689,0001,379,0001,607,00045,500919306000613000714000214200429100499800542535000Share capitalGeneral reserveAsset revaluation surpluss893,000383,000306,00015820002695525242597279459799072- 319,475 Hyun JooKIM11801227510002566000InventoriesLand Equipment 385,000770,000898,0001,078,000180,00037,95041,9258693,0001,386,0001,616,00045,900928308000616000718000215600431200502600556535000Share capitalAsset revaluation surplussRetained earnings898,000385,000308,00015910002710965216877278287771912- 243,175 JeevanGAUTAM11801275530002662000InventoriesLand Furniture399,000799,000932,0001,118,000186,00039,35044,0255718,0001,438,0001,678,00048,7009010319000639000746000223300447300522200654535000Share capitalRetained earningsGeneral reserve932,000399,000319,000165000028143452814352943435129090- 300,780 AlonikaSHAH11801285540002682000InventoriesLand Vehicle 402,000805,000939,0001,127,000188,00039,65044,47510724,0001,449,0001,690,00049,300919322000644000751000225400450800525700675535000Share capitalGeneral reserveAsset revaluation surpluss939,000402,000322,000166300028366552552992937299100644- 237,130 RoshesSHRESTHA11801291540002694000InventoriesLand Machinery 404,000808,000943,0001,132,000189,00039,85044,7754727,0001,454,0001,697,00049,700928323000646000754000226100452200527800689535000Share capitalAsset revaluation surplussRetained earnings943,000404,000323,00016700002847995227840292184073845- 337,125 AlishaBARUWAL11801297540002706000InventoriesLand Plant406,000812,000947,0001,136,000189,00040,05040,0758731,0001,462,0001,705,00040,10090103250006500007580002275004550005306003535000Share capitalRetained earningsGeneral reserve947,000406,000325,000167800028561352856142991614135479- 256,363 ManiMAHARJAN 11801301540002714000InventoriesLand Equipment 407,000814,000950,0001,140,000190,00040,15040,2255733,0001,465,0001,710,00040,30091932600065100076000022820045570053200010535000Share capitalGeneral reserveAsset revaluation surpluss950,000407,000326,000168300028640052577602971760107755- 307,200 Prajwal BajraBAJRACHARYA11801319550002750000InventoriesLand Furniture413,000825,000963,0001,156,000193,00040,75041,12510743,0001,485,0001,733,00041,50092833000066000077000023100046200053900052535000Share capitalAsset revaluation surplussRetained earnings963,000413,000330,00017060002903525232282298228278757- 243,410 PhoutthakoneDOUANGPHACHANH11801338560002788000InventoriesLand Vehicle 418,000836,000976,0001,171,000195,00041,25041