Question

In: Accounting

How much cash do I have at the end of period 2, 3, and 4? Please...

How much cash do I have at the end of period 2, 3, and 4?

Please add calculations for each period.

Period Debit or Credit Value Type Account
0 Credit(+) $1,500,000 Equity Startup Capital
0 Debit(+) $1,500,000 Asset Cash
0 Debit(+) $300,000 Asset Property, Plant & Equipment
1 Debit(+) $26,000 Expense Operating Costs
1 Credit(-) $26,000 Asset Cash
1 Credit(+) $126,114 Revenue Revenue
1 Debit(+) $126,114 Asset Cash
1 Debit(+) $240,000 Asset Inventory
1 Credit(+) $240,000 Asset Cash
1 Debit(+) $67,261 Expense Cost of Goods Sold
1 Credit(-) $67,261 Asset Inventory
2 Debit(+) $26,000 Expense Operating Costs
2 Credit(-) $26,000 Asset Cash
2 Credit(+) $473,886 Revenue Revenue
2 Debit(+) $473,886 Asset Cash
2 Debit(+) $90,000 Asset Inventory
2 Credit(+) $90,000 Asset Cash
2 Debit(+) $284,332 Expense Cost of Goods Sold
2 Credit(-) $284,332 Asset Inventory
2 Debit(+) $37,500 Expense Loan Payment - Interest
2 Credit(-) $37,500 Asset Cash
2 Debit(+) $250,000 Liability Loan Payment - Principal
2 Credit(-) $250,000 Asset Cash
2 Debit(+) $40,000 Expense Other Costs
2 Credit(-) $40,000 Asset Cash
2 Debit(+) $6,000 Expense Market Research Costs
2 Credit(-) $6,000 Asset Cash
2 Debit(+) $2,500 Expense Sales Promotion - OKC
2 Credit(-) $2,500 Asset Cash
2 Debit(+) $2,500 Expense Sales Promotion - Tulsa
2 Credit(-) $2,500 Asset Cash
2 Debit(+) $2,500 Expense Sales Promotion - Stillwater
2 Credit(-) $2,500 Asset Cash
2 Debit(+) $2,500 Expense Product Line Brand - OKC
2 Credit(-) $2,500 Asset Cash
2 Debit(+) $2,500 Expense Product Line Brand - Tulsa
2 Credit(-) $2,500 Asset Cash
2 Debit(+) $2,500 Expense Product Line Brand - Stillwater
2 Credit(-) $2,500 Asset Cash
3 Debit(+) $26,000 Expense Operating Costs
3 Credit(-) $26,000 Asset Cash
3 Credit(+) $799,731 Revenue Revenue
3 Debit(+) $799,731 Asset Cash
3 Debit(+) $682,500 Asset Inventory
3 Credit(+) $682,500 Asset Cash
3 Debit(+) $559,812 Expense Cost of Goods Sold
3 Credit(-) $559,812 Asset Inventory
3 Debit(+) $1,500 Expense Market Research Costs
3 Credit(-) $1,500 Asset Cash
3 Debit(+) $2,500 Expense Research & Development - Flavor Varieties
3 Credit(-) $2,500 Asset Cash
3 Debit(+) $5,000 Expense Research & Development - Ingredient Quality
3 Credit(-) $5,000 Asset Cash
3 Debit(+) $15,000 Expense Research & Development - Update Equipment
3 Credit(-) $15,000 Asset Cash
3 Debit(+) $3,750 Expense Sales Promotion - OKC
3 Credit(-) $3,750 Asset Cash
3 Debit(+) $2,500 Expense Sales Promotion - Tulsa
3 Credit(-) $2,500 Asset Cash
3 Debit(+) $5,000 Expense Sales Promotion - Stillwater
3 Credit(-) $5,000 Asset Cash
3 Debit(+) $3,750 Expense Product Line Brand - OKC
3 Credit(-) $3,750 Asset Cash
3 Debit(+) $2,500 Expense Product Line Brand - Tulsa
3 Credit(-) $2,500 Asset Cash
3 Debit(+) $5,000 Expense Product Line Brand - Stillwater
3 Credit(-) $5,000 Asset Cash
4 Debit(+) $26,000 Expense Operating Costs
4 Credit(-) $26,000 Asset Cash
4 Credit(+) $723,876 Revenue Revenue
4 Debit(+) $723,876 Asset Cash
4 Debit(+) $315,000 Asset Inventory
4 Credit(+) $315,000 Asset Cash
4 Debit(+) $381,945 Expense Cost of Goods Sold
4 Credit(-) $381,945 Asset Inventory
4 Debit(+) $1,500 Expense Market Research Costs
4 Credit(-) $1,500 Asset Cash
4 Debit(+) $2,500 Expense Research & Development - Flavor Varieties
4 Credit(-) $2,500 Asset Cash
4 Debit(+) $5,000 Expense Research & Development - Ingredient Quality
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Sales Promotion - OKC
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Sales Promotion - Tulsa
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Sales Promotion - Stillwater
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Product Line Brand - OKC
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Product Line Brand - Tulsa
4 Credit(-) $5,000 Asset Cash
4 Debit(+) $5,000 Expense Product Line Brand - Stillwater
4 Credit(-) $5,000 Asset Cash

Solutions

Expert Solution

Cash balance at the end of period 2,3,4:

For the period ended 2 For the period ended 3 For the period ended 4
0 Debit(+) $1,500,000 Beginning Debit $1,369,500 Beginning Debit $1,414,231
1 Debit(+) $126,114 3 Debit(+) $799,731 4 Debit(+) $723,876
2 Debit(+) $473,886
Total Debit (i) $2,100,000 Total Debit (i) $2,169,231 Total Debit (i) $2,138,107
1 Credit(-) $26,000 3 Credit(-) $26,000 4 Credit(-) $26,000
1 Credit(+) $240,000 3 Credit(+) $682,500 4 Credit(+) $315,000
2 Credit(-) $26,000 3 Credit(-) $1,500 4 Credit(-) $1,500
2 Credit(+) $90,000 3 Credit(-) $2,500 4 Credit(-) $2,500
2 Credit(-) $37,500 3 Credit(-) $5,000 4 Credit(-) $5,000
2 Credit(-) $250,000 3 Credit(-) $15,000 4 Credit(-) $5,000
2 Credit(-) $40,000 3 Credit(-) $3,750 4 Credit(-) $5,000
2 Credit(-) $6,000 3 Credit(-) $2,500 4 Credit(-) $5,000
2 Credit(-) $2,500 3 Credit(-) $5,000 4 Credit(-) $5,000
2 Credit(-) $2,500 3 Credit(-) $3,750 4 Credit(-) $5,000
2 Credit(-) $2,500 3 Credit(-) $2,500 4 Credit(-) $5,000
2 Credit(-) $2,500 3 Credit(-) $5,000
2 Credit(-) $2,500
2 Credit(-) $2,500
Total Credit (ii) $730,500 Total Credit (ii) $755,000 Total Credit (ii) $380,000
Balance at the
end of perid 2 (i-ii)
$1,369,500 Balance at the
end of perid 3 (i-ii)
$1,414,231 Balance at the
end of perid 4 (i-ii)
$1,758,107

Related Solutions

How do I solve this equation? (1/3(5)-1/4(-3))(-3/4(3))
How do I solve this equation? (1/3(5)-1/4(-3))(-3/4(3))
​​​​​ 1 Do you own a pet? 2 How old are you? 3 How much do...
​​​​​ 1 Do you own a pet? 2 How old are you? 3 How much do you weigh? (lbs) 4 Male or Female? 5 Do you drink alcohol? 6 How often do you watch movies at the theater per month? 7 How often do you eat fast food per week? 8 Do you like spicy food? 9 Do you prefer Android or iOS? 10 Do you prefer Windows of Mac? 11 How many times a year do you go on...
Tom is planning to invest the following amounts at 4 percent interest. How much money will he have saved at the end of year 3?
1.Tom is planning to invest the following amounts at 4 percent interest. How much money will he have saved at the end of year 3?End of year:Amount saved:1$5002$8003$900   Group of answer choices$2,200.00$2,238.47$2,272.80$2,309.16$2,363.712.Which of the following statements is false?Group of answer choicesA dollar today is worth more than a dollar tomorrow.A safe dollar is worth more than a risky dollar.For a given r (or I), as t (or N) increases, PV increases.An ordinary annuity and a perpetuity are both a series of...
Tom borrowed $600 at 10% per year, simple interest, for 3 years. How much did he have to repay (principal + interest) at the end of the 3 year period?
Tom borrowed $600 at 10% per year, simple interest, for 3 years. How much did he have to repay (principal + interest) at the end of the 3 year period?
Using the financial statements of a company over a 3 year period how do I calculate...
Using the financial statements of a company over a 3 year period how do I calculate the intrinsic value of a stock using the discount cash free flow method? what figures in the financial statement do I use in the calculations
How do I prepare a 10ml mixture of 0.0200M Cr(NO3)3 and 0.0752M Co(NO3)2 if I have...
How do I prepare a 10ml mixture of 0.0200M Cr(NO3)3 and 0.0752M Co(NO3)2 if I have a stock solution of 25ml of 0.0500M Cr(NO3)3 and another stock solution of 25ml of 0.1880M Co(NO3)2?
in verilog if i have a hex number how do i get a specific 4 bits?...
in verilog if i have a hex number how do i get a specific 4 bits? for exampe if i have a hex number 5055 how do i get the last four bits which would be 0101?
What is the equivalent worth at the end of period 4 of 4 uniform per period...
What is the equivalent worth at the end of period 4 of 4 uniform per period amounts of 600 starting at the end of period 1 followed after that ends by 7 uniform period amounts of 800 using an interest rate of 7.00%.
JUST DO QUESTION 2 and 3, not 1. The answer to one is 4% I believe....
JUST DO QUESTION 2 and 3, not 1. The answer to one is 4% I believe. Ann gets a fully amortizing 30-year fixed rate mortgage with quarterly payments for $1,000,000. The interest rate is 4%, compounded quarterly. She prepays the mortgage in 1 quarter (i.e. she makes the 1st payment and immediately prepays the remaining balance). What is Ann’s APR? Notes: a quarter equals 3 months, one year consists of 4 quarters, APR is annual. Modify question 1: At the...
Assume i=8% year. How much money do I have to deposit today(year 0) in an account...
Assume i=8% year. How much money do I have to deposit today(year 0) in an account that will generate $25000 from year 12 to infinity.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT