Please put each answer in Excel with formulas
1.Evening Story Corporaon has sales of $4,734,140; income tax of $354,052; the selling, general and administrave expenses of $298,754; depreciaon of $332,311; cost of goods sold of $2,572,040; and interest expense of $163,663. Calculate the amount of the firm’s gross profit.
This is the Answer (2,162,100)
2. Banana Box Corporaon has sales of $4,865,530; income tax of $435,276; the selling, general and administrave expenses of $243,637; depreciaon of $389,453; cost of goods sold of $2,422,540; and interest expense of $143,953. Calculate the amount of the firm’s income before tax?
This is theAnswer (1,665,947)
3. Garden Pro Corporaon has sales of $4,670,270; income tax of $569,623; the selling, general and administrave expenses of $210,720; depreciaon of $300,327; cost of goods sold of $2,751,400; and interest expense of $163,136. Calculate the firm’s net income?
This is the Answer: (675,064)
4. Killer Whale, Inc. has the following balance sheet statement items: total current liabilies of $866,301; net fixed and other assets of $1,015,750; total assets of $3,461,010; and long‑term debt of $989,183. What is the amount of the firm’s current assets?
This is the Answer: (2,445,260)
5. Purple Dalia, Inc. has the following balance sheet statement items: current liabilies of $707,971; net fixed and other assets of $1,165,460; total assets of $2,956,270; and long‑term debt of $907,037. What is the amount of the firm’s total stockholder’s equity
This is the Answer : (1,341,262)
6. Scare Train, Inc. has the following balance sheet statement items: current liabilies of $669,514; net fixed and other assets of $1,490,840; total assets of $2,921,030; and long‑term debt of $864,170. What is the amount of the firm’s net working capital?
This is the Answer: (760,676)
7. Moby Dick Corporaon has sales of $4,419,790; income tax of $391,361; the selling, general and administrave expenses of $230,264; depreciaon of $306,025; cost of goods sold of $2,485,650; and interest expense of $125,169. Calculate the amount of the firm’s aer‑tax cash flow from operaons
This is the Answer: (1,312,515)
0 comments