You are a loan officer for National Bank. You have a loan application submitted by a company for $50,000. This company just got a prior loan for $45,000 and has not made the first payment. This gives you an uneasy feeling as you examine a loan application from ABC, Co.
The application included the following financial statements.
ABC, Co.
Income
Statement
For the Year Ended December 31, 2018
Sales revenue
Cost of goods sold
Depreciation expense
Remaining expenses
Net income
$100,000
(50,000)
(5,000)
(25.000)
$20,000
ABC, Co.
Balance Sheet
December 31, 2018
Cash
Accounts receivable
Inventory
Depreciable asset
Accumulated depreciation
$5,000
25,000
20,000
$55,000
(5,000)
Total $100,000
(SECOND HALF OF THE QUESTION IS IN THE PHOTO

sumif(range,criteria,sum_range)

the range is range of cells you want to be included.

criteria in the form of a number, expression, or text that defines which cells will be added. for example, criteria can be expressed as 32, "32", "> 32", "apples".

sum_range is the actual cells to add if their corresponding cells in range match the criteria

c

explanation:

c because the item on a bank statement is also referred to as an account statement. in addition, it provides the beginning balance, ending balance, statement date, transaction date for each transaction, payee, customer name and address, statement period, the account holder's account number, and the bank's customer service number

the law, public safety, corrections, and security cluster prepares people for careers in planning, managing, and providing legal, public safety, protective services and homeland security, including professional and technical support services.