Preparation of accounting records $$ using spreadsheets

The trial balance of Betty Investment Advisers as at $30$ June $2024$ follows:

BETTY INVESTMENT ADVISERS

Unadjusted Trial Balance

As at $30$ June $2024$

ACCOUNT TITLE DEBIT CREDIT

Cash $28,000$

Accounts receivable $47,000$

Office supplies $5,000$

Equipment $21,000$

Accumulated depreciation$$Equip $11,000$

Accounts payable $16,000$

Salaries payable

Unearned revenue $2,000$

Loans payable $23,000$

Frank, capital $31,000$

Frank, withdrawals $27,000$

Service revenue $95,000$

Insurance expense $3,000$

Salaries expense $35,000$

Supplies expense

Interest expense $4,000$

Rent expense $8,000$

Depreciation expense$$Equip$.$

Total $178,000178,000$

$($Note: You can copy this table into Excel$)$

Required:

$1)$ Formulate five adjustments $($with special attention to dates and months$)$ and journalise the adjusting entries in Excel. Ensure that these adjustments vary from each other and cover a range of transaction types. Examples of different types of adjustments include accrued service revenue, depreciation, accrued salary expense, expired prepaid rent, supplies used, and unearned revenue. Before making the adjusting entries in A$.$Q$1($page $3),$ provide the details of each adjustment. After detailing the adjustments, prepare the adjusting entries $($formulas are not required$)..$

Using your $$Unadjusted Trial Balance$$ and adjusting entries prepared above, prepare the ten$-$column worksheet in Excel for the period ended on $30$ June $2024.$ Use formulas to generate all figures in the $$worksheet$$ from the $$data$$ section. Use the IF function for the $$Profit$$ or $$Loss$$ and also to check that the debit and credit columns balance.

$3)$ Using the ten$-$column worksheet prepared above as your $$data$,$ prepare the income statement, statement of changes in equity and classified balance sheet in Excel. Use formulas to generate all of the figures in the financial statements.

Note : Please give all answers in excel spreadsheet only. Preparation of accounting records $-$ using spreadsheets The trial balance of Betty Investment Advisers as at $30$ June $2024$ follows:

$\backslash$table$[[$BETTY INVESTMENT ADVISERS$],[$As at $30$ June $2024],[],[$ACCOUNT TITLE,DEBIT,CREDIT$],[$Cash$,28,000,],[$Accounts receivable,$5,000,],[$Office supplies,$21,000,],[$Equipment$,,11,000],[$Accumulated depreciation$-$Equip,,$16,000],[$Accounts payable,,$],[$Salaries payable,,$2,000],[$Unearned revenue,$27,000,31,000],[$Loans payable,,$95,000],[$Frank$,$ capital,$3,000,],[$Frank$,$ withdrawals,$35,000,],[$Service revenue,,$],[$Insurance expense,$4,000,],[$Salaries expense,$8,000,],[$Supplies expense,,$],[$Interest expense,$178,000,178,000],[$Rent expense,,$],[$Depreciation expense$-$Equip.,,$],[$Total$,100,]]$

$($Note: You can copy this table into Excel$)($Note: You can copy this table into Excel$)$

Required:

Formulate five adjustments $($with special attention to dates

and months$)$ and journalise the adjusting entries in Excel.

Ensure that these adjustments vary from each other and

cover a range of transaction types. Examples of different

types of adjustments include accrued service revenue,

depreciation, accrued salary expense, expired prepaid rent,

supplies used, and unearned revenue. Before making the

adjusting entries in A$.$Q$1($page $3),$ provide the details of

each adjustment. After detailing the adjustments, prepare

the adjusting entries $($formulas are not required$)..$

Using your 'Unadjusted Trial Balance' and adjusting

entries prepared above, prepare the ten$-$column worksheet

in Excel for the period ended on $30$ June $2024.$ Use

formulas to generate all figures in the 'worksheet' from

the 'data' section. Use the IF function for the 'Profit' or

'Loss' and also to check that the debit and credit columns

balance.

Using the ten$-$column worksheet prepared above as your

'data', prepare the income statement, statement of changes

in equity and classified balance sheet in Excel. Use

formulas to generate all of the figures in the financial

statements.