Question

In: Accounting

Excel format! Please show calculations, it is important! Thank you! PROBLEM # 1 ABC Co. purchased...

Excel format! Please show calculations, it is important! Thank you!

PROBLEM # 1

ABC Co. purchased 1,000 shares of XYZ for $23 each this year and classified the investment as a trading security. ABC sold 400 shares of the stock for $24 each. At year end the price per share of the XYZ Company had increased to $26.

Instructions

Prepare the journal entries for these transactions and any year-end adjustments.

PROBLEM # 2

On January 1, 2017, LabTech Inc. purchased 40% of the common shares of UnderTech Company for $280,000. During the year, UnderTech earned net income of $140,000 and paid dividends of $34,000.

Instructions

Prepare the entries for LabTech to record the purchase and any additional entries related to this investment in UnderTech Company in 2017.

Solutions

Expert Solution

Problem -1 Account Titles Debit $ Credit $
Investment in XYZ - Trading     23,000
Cash ( 1,000 x 23 )     23,000
Cash ( 400 x 24 )        9,600
Investment in XYZ - Trading        9,200
Gain on sale of Investment           400
Fair Value Adjustment ( 26 - 23 ) x 600        1,800
Unrealized Holding gain or loss        1,800
Problem -2 Account Titles Debit $ Credit $
Investment in Undertech Company 2,80,000
Cash 2,80,000
Investment in Undertech Company     56,000
Investment Revenue ( 140,000 x 40% )     56,000
Cash ( 34,000 x 40% )     13,600
Investment in Undertech Company     13,600

Related Solutions

Please if you could do each problem, and show steps for excel! Thank you! You will...
Please if you could do each problem, and show steps for excel! Thank you! You will graduate in a few years and start working and it’s never too early to start planning for your retirement and other financial events. Let’s fast forward to the beginning of your career. Here’s some assumptions to help you get started. Your starting annual salary will be $60,000. You plan to work for 43 years before retiring. You expect your salary to grow at an...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL]...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Income Statement Net Sales: $1500 Costs: $350 Net Income: $1150 Balance Sheet Assets $700 = $700 Debt $600 Equity 100 = $700 Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells...
PLEASE ANSWER USING EXCEL. please show formulas used in excel. THANK YOU :) Parry Enterprises sells copy paper by the case to office supply stores. Each case of paper costs Parry $15. The operating costs are $30,000 per period. Each period, Parry sells approximately 15,000 cases of copy paper at $35 per case. Texas Office Emporium is requesting an order of 4,000 cases of copy paper in the next period at a price of $25 per case. Since Parry has...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these particulars: Face amt. of Bonds 630,000 Matures on 1-1-2027, in 10 yrs. Stated annual rate of int. 7.25% Effective annual rate of interest 6.00% Int. is paid every six months; 6-30, 12-31 Req. 1, Assume the effective Interest Method in accounting for these Bonds, build a 10-year amortization table Req. 2, Give General Journal entries to record the sale of the bonds, and the...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these...
Please show all work and calculations, Thank you! On 1-1-2017 Avion, Inc. Sold Bonds with these particulars: Face amt. of Bonds 630,000 Matures on 1-1-2027, in 10 yrs. Stated annual rate of int. 7.25% Effective annual rate of interest 6.00% Int. is paid every six months; 6-30, 12-31 Req. 1, Assume the effective Interest Method in accounting for these Bonds, build a 10-year amortization table Req. 2, Give General Journal entries to record the sale of the bonds, and the...
Please show all calculations in MS Excel. No credit will be earned unless you show your...
Please show all calculations in MS Excel. No credit will be earned unless you show your calculations. Problem 1: CAPM: 5-Points: If the risk-free rate is 0.0200, the return of the market is 0.1350, and the beta is 1.18, what is the required rate of return of the stock using the CAPM equation? Please note that the return of the market is not the same as the market risk premium. Problem 2: Growth Rate: (Equation 9.11, page 373): 5-Points: If...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use...
Please solve A, B, and C. Please use excel. Please show work. Thank you. A. Use the stocks of Apple, SAP, IBM, Oracle, and Amazon Download the historical data of weekly stock prices and S&P 500 index prices from year 2017-2019 on the website of yahoo finance and save it on an excel file. B. Use a different sheet to save the market adjusted prices of Apple, SAP, IBM, Oracle, and Amazon t and the index. For each stock, compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT