1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
BartSMP [9]
3 years ago
12

Add a new field named LoanPayment using the Expression Builder. Insert the Pmt function to determine the monthly payment for a 2

-year loan, paid monthly, with a 5% yearly interest rate. The present value is 25000 minus the savings balance. For example, if the purchase price were 25000, with 5000 in savings to put toward the purchase, your present value would be 20000. Ensure the number displays as a positive number.

Business
1 answer:
pogonyaev3 years ago
7 0

Solution and Explanation:

Step 1:  Start Access. Open the downloaded Access file named exploring_a03_Grader_a1.accdb.

Step 2:  Assume that there is a table Loans with the following attributes as shown in the screenshot.

Step 3:  Create a query using Query Design. From the Clients table, display the client’s FirstName and LastName. From the Accounts table, select the Savings Balance and OpenDate. Sort the query by savings balance in descending order.

   Add a calculated field named AccountTime that calculates the number of days each client’s accounts have been open. Assume today’s date is 12/31/2017. Recall dates must be enclosed in # to denote to Access it is a date. Format the results in General Number format. Save the query as Account Longevity, and close the query.

Step 4: Create a query using Query Design. From the Clients table, display the client first name and last name. From the Accounts table, select the savings balance.

   Add appropriate grouping, so the client’s total retirement account savings balances are displayed. Add a sort so the highest total savings balances are displayed first.

Step 5:  Switch to Datasheet view. Add a totals row displaying the count of the last name and the average of total savings balances. Save the query as Total Balances By Client and close the query.

Step 6:  Create a copy of the Total Balances By Client query. Name the query Total Balances By State. Open the query in Design view and remove the client name from the query. Add grouping by the client’s state.

   Sort by the client’s state in Ascending order and remove the sort on the savings balance. Add criteria so clients with retirement account savings balances of $10,000 or more are factored in to the query. Save and close the query.

Step 7:   Create a new query using Query Design. From the Clients table, select the client first name, last name, and state. From the Accounts table, select the Savings Balance. Add criteria so only customers with balances under $15,000 are displayed.

Step 8:  Enter the sample data (one record) as shown in the screenshot.

As present value is given as 25000, loan amount is taken as 25000.

As savings balance is given as 5000, savings balance is taken as 5000.

Step 9: SS

Step 10:  Then an expression builder is opened as shown in the screenshot:

Step 11:  Then enter the expression pmt(0.5/12, 2*12, - (Loan Amount] – [Savings balance]), 0, 0) as shown in the screenshot.

You might be interested in
The following information is available for Lock-Tite Company, which produces special-order security products and uses a job orde
lbvjy [14]

Answer:

Exercise 15-8

1. Raw materials purchases for cash.

Raw Materials $210,000 (debit)

Cash $210,000 (credit)

2. Direct materials usage.

Work In Process : Indirect Materials $186,000 (debit)

Raw Materials $186,000 (credit)

3. Indirect materials usage.

Work In Process : Direct Materials $15,000 (debit)

Raw Materials $15,000 (credit)

Exercise 15-9

1. Direct labor usage.

Work In Process : Direct Labor $265,000 (debit)

Salaries and Wages Payable $265,000 (credit)

2. Indirect labor usage.

Work In Process : Indirect Labor $80,000 (debit)

Salaries and Wages Payable $80,000 (credit)

3. Total payroll paid in cash.

Salaries and Wages Payable :  $345,000 (debit)

Cash  $345,000 (credit)

Explanation:

Raw Materials - T Account (To determine the Materials Transferred to Production)

Debit

Opening Balance                                                 $ 43,000

Add Purchases                                                    $210,000

Totals                                                                   $253,000

Credit

Closing Balance                                                   $ 52,000

Transferred to Production (Balancing figure)    $201,000

Totals                                                                   $253,000

Thus, Direct Materials = $201,000 - 15,000 = $186,000

3 0
3 years ago
Shen spends $200 to purchase legal service from Rowan and Martin Associates. Valerie spends $8 to order a mojito cocktail. Shen
Vladimir [108]

Answer:

(1) Shen spends $200 to purchase legal service from Rowan and Martin. Associates - Dollars

(2) Valerie spends $8 to order a mojito cocktail - Dollars.

(3) Shen earns $375 per week working for Little Havana - Inputs.

Explanation:

<em>(1) & (2) statements in the "Answer" above</em> are <em>purchase on cash </em>transactions. Hence, they imply the flow of <em>dollars</em> from the household to the firm.

<em>(3) statement in the</em> <em>"Answer" above</em>  implies giving of <em>factor input labor services</em> by Shen to Little Havana. Hence, it indicates the flow of <em>inputs </em>from the household to the firm.

4 0
3 years ago
On December 31, after making a concerted effort, management determines that it will not be able to collect the $1,200 owed to it
zvonat [6]

Answer:

See explanation section

Explanation:

To record the journal entry to write off the uncollectible account according to the direct write-off method, we have to use bad dad expanse instead of an allowance account.

December 31         Bad Debt Expense           Debit     $1,200

                              Account receivable - Acme, Inc.      Credit    $1,200

Note: As the company did not get the money from the Acme, Inc., They treated the expense as irrecoverable.

4 0
3 years ago
Damaris is a member of AASA. What did she most likely learn from a meeting she recently went to?
Temka [501]

Answer: B. there is a conference for school principals coming to town.  I hope this  helps everyone :)

I took a test so i know this answer is correct! :)

7 0
3 years ago
Read 2 more answers
: ____ refers to all of the pay and benefits provided to employees for the completion of work.
steposvetlana [31]
The answer is total compensation. 
5 0
3 years ago
Other questions:
  • What does the investment component of GDP measure? a. spending on domestically produced goods by foreign buyers b. spending by h
    5·1 answer
  • Prepare the journal entry, if any, required to record each of the initial business activities on September 1. (If no entry is re
    6·1 answer
  • As the facility manager, you listen to your employees and demonstrate concern and care about their social needs, but still make
    14·1 answer
  • Farmers Produce Inc. and Growers Market enter into a contract for the delivery of vegetables. Some of the produce spoils before
    13·1 answer
  • Suppose you deposit ​$ cash into your checking account. By how much will the total money supply increase as a result when the re
    9·1 answer
  • Imagine that an economic recession erodes consumer confidence. As a result, the marginal propensity to consume drops from .8 to
    11·1 answer
  • Keenan Industries has a bond outstanding with 15 years to maturity, an 8.25% nominal coupon, semiannual payments, and a $1,000 p
    14·1 answer
  • Which particular demographic do you think has the most effect on consumer purchasing decisions? Explain.
    12·1 answer
  • True or False conflicts can be difficult to resolve when people have strong emotions
    13·1 answer
  • The inventory of Royal Decking consisted of five products. Information about ending inventory is as follows:
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!