Question - Please answer the following question in Excel.

Cash and Accrual Income Statements for a Manufacturer Drysdale Company was established to manufacture components for the auto industry. The com-ponents are shipped the same day they are produced. The following events took place during the first year of operations:

a. Issued common stock for a $ 50,000 cash investment.

b. Purchased delivery truck at the beginning of the year at a cost of $ 10,000 cash. The truck is expected to last five years and will be worthless at the end of that time.

c. Manufactured and sold 500,000 components the first year. The costs incurred to manufacture the components are ( 1) $ 1,000 monthly rent on a facility that included utilities and insurance, ( 2) $ 400,000 of raw materials purchased on account ($ 100,000 is still unpaid as of year- end, but all materials were used in manufacturing), and ( 3) $ 190,000 paid in salaries and wages to employees and supervisors.

d. Paid $ 100,000 to sales and office staff for salaries and wages.

e. Sold all components on account for $ 2 each. As of year- end, $ 150,000 is due from customers.

Required -

How much revenue will Drysdale recognize under the cash basis and under the accrual basis?

Describe how Drysdale should apply the matching principle to recognize expenses.

Prepare an income statement under the accrual basis. Ignore income taxes.