Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
Answer:
<u>b. Sales tax in a state with no income tax</u>
Explanation:
- Under the laws of the united states, itemized deductions are eligible expenses that an individual taxpayer can claim on federal income if available.
- Based on there taxable incomes the taxes can be deduced and the sales taxes with no income tax do not come under the deductible tax.
- The list of expenses can also be itemized by there are limited to the tax year.
Answer:
a) $28 Million
b) -$24 Million
Explanation:
The first part of the question is to determine the pension liability tht should be reported in the balance sheet
To do this, we use the following formula
Projected Benefit Obligation - The Plan Assets
= $65 million - $37 Million = $28 Million
Part B) This part says to dettermine the amount JDS would report if the planned asset increase to $89 million
The formula Projected Benefit Obligation - The Plan Assets still should be used but there is a difference as follows
$65 million - $89 Million = -$24 Million
This is known as in-sample forecast. It estimated the model using all available data and then comparing it to the model's fixed values to the actual realizations. But, this method is known to attract an overly positive picture of the model's forecasting ability since common fitting algorithms tend to take pains to avoid big prediction errors and are also inclined to overfitting (mistaking noise for signal in the data).
Answer:. CSV and PDF
Explanation:
QuickBooks is an Accounting software that was developed to mainly help small to medium size companies maintain a proper accounting system.
The Wholesale billing option enables the owner to pay the subscription for the clients that they moved to the wholesale billing list.
When downloading an itemized invoice for this there are 2 file formats that QuickBooks permits people to use which are CSV and PDF file formats.