1. Vlookup and Hlookup
2. Pivot table
3. some IF functions such as countif, countifs
C. The adjusting entry for accrued interest on a note receivable would include a credit to interest revenue
Answer:
5.925%
Explanation:
For computing the cost of debt, first we have to determine the YTM by using the Rate formula that is shown in the attachment
Given that,
Present value = $1,050
Assuming figure - Future value or Face value = $1,000
PMT = 1,000 × 8% = $80
NPER = 20 year - 1 year = 19 year
= Rate(NPER;PMT;-PV;FV;type)
The present value come in negative
So, after solving this,
1. The pretax cost of debt is 7.50%
2. And, the after tax cost of debt would be
= Pretax cost of debt × ( 1 - tax rate)
= 7.50% × ( 1 - 0.21)
= 5.925%
Answer:
A. $70,000
Explanation:
From the information given, we discover that
Gross profit from sporting goods business = $100,000
Subtract: other Expenses = 11500
Subtract: Building depreciation expenses (10000 × 55%) = 5500
Subtract: Mortgage Interest (10000 × 55%) = 5500
Subtract: Depreciation on vehicle used for business = 3000
Less: Utilities for Ground Floor = 4500
Net Self employment Income = $70,000
Note that 55% is used for ground floor, it is calculated as 100 - 45% used by tenant, therefore, for business purpose 55% will be taken.