Question: please do the problem with excel In excel, show the following transactions and how it will impact the income Statement and Balance sheet for the
In excel, show the following transactions and how it will impact the income Statement and Balance sheet for the month of Januaary - assume all beginning balances are $0 : 1. The Company is working on an intercompany project. The project is sold at cost. In the manth of anuary, the Company incurs $300,000 of labor costs and $50,000 of material costs on the project: 2. The Sampany has a Zero Balance Account with Mother company. The Company received \$25, a00 in cash receipts on 1.5/21 3. The Company has a zero Balance Account with Mother company. The Company runs a speciaf bonus payroll for: $10,000 on 1/25/2 4. The Sampanay recelves and invoice for Business insurance for $120,000 for the period of 1/112/31 5. The Campainy pays emplovees an weekly basis and payroll for the period of 1/302/5 is processed on 2/9. Assame payroll averaees $10,000 a day: 6. Pease provide a poo insurance schedule for 1/112/31 for the expense llsted in question 4. In excel, show the following transactions and how it will impact the income Statement and Balance sheet for the month of Januaary - assume all beginning balances are $0 : 1. The Company is working on an intercompany project. The project is sold at cost. In the manth of anuary, the Company incurs $300,000 of labor costs and $50,000 of material costs on the project: 2. The Sampany has a Zero Balance Account with Mother company. The Company received \$25, a00 in cash receipts on 1.5/21 3. The Company has a zero Balance Account with Mother company. The Company runs a speciaf bonus payroll for: $10,000 on 1/25/2 4. The Sampanay recelves and invoice for Business insurance for $120,000 for the period of 1/112/31 5. The Campainy pays emplovees an weekly basis and payroll for the period of 1/302/5 is processed on 2/9. Assame payroll averaees $10,000 a day: 6. Pease provide a poo insurance schedule for 1/112/31 for the expense llsted in question 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
