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]
2 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:
pogonyaev2 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
Suppose the demand for Digital Video Recorders (DVRs) is given by Q = 250 - .25p + 4pc, where Q is the quantity of DVRs demanded
PIT_PIT [208]

The question is incomplete. Here is the complete question

Suppose the demand for Digital Video Recorders (DVRs) is given by Q = 250 - .25p + 4pc, where Q is the quantity of DVRs demanded (in 1000s), p is the price of a DVR, and pc is the price of cable television. How much does the quantity demanded for DVRs change if the p rises by $40? A) drops by 10,000 DVRs B) increases by 16,000 DVRs C) drops by 2,500 DVRs D) increases by 4,000

Answer:

Drops by 10,000 DVRs

Explanation:

The demand for digital video recorders is expressed by

Q= 250- .25p+4pc

Where

Q represents the quantity demanded by the customers

P represents the price of DVR

pc represents the price of cable television

Since the factor of p in the expression above is negative, this implies that the quantity of DVR demanded in the market will reduce

If the price of DVR increase by $40, then the quantity demanded will reduce by

= 0.25×40×1000

= 10×1000

= 10,000 units

Hence the quantity of DVRs drops by 10,000 DVRs if the price is increased to $40

3 0
2 years ago
Lucky Company's direct labor information for the month of February is as follows: Actual direct labor hours worked (AQ) 61,500 S
Rufina [12.5K]

Answer:

d. $18,900 unfavorable.

Explanation:

Direct labor efficiency variance = SR*(SH-AH)

18000 = SR*(63000-61500)

18000 = 1500 SR

SR = $12

Total standard direct labor cost for February = 63000*12= $756,000

Direct labor flexible-budget variance = $774,900 - $756,000 = $18900 Unfavorable

3 0
3 years ago
Define the term human rights violations​
anygoal [31]

Answer:

Human rights violation or abuse means any harm committed by a State or a business enterprise, through acts or omissions in the context of business activities, against any person or group of persons, individually or collectively, including physical or mental injury, emotional suffering, economic loss or substantial impairment of their human rights, including environmental rights, through acts or omissions in the context of business activities of a transnational character.

Explanation:

7 0
2 years ago
All of the following are categories of data that marketing researchers typically collect except for which one? a. Fears b. Behav
swat32

Answer:

The correct answer is A

Explanation:

Market research is the research which is a scientific study and it is performed in order to collect the important market information, enable the business to make the right decisions.

The collection of the data in the marketing research is defined as the detailed as well as informative procedure, in which the planned search for the all the relevant data that is made by the researcher.

So, the categories which are used for the data that  marketing researchers usually collect are behavior, attitudes and intentions.

3 0
3 years ago
Is there really a need to develop training improve customer service? Why?​
il63 [147K]

Answer:

Yes

Explanation:

The customer must feel happy, and comfortable in the environment that shopkeeps set up. An unhappy customer is far less likely to purchase in quantity and may be less attracted to products. The experience of shopping must be positive if the manager wishes to succeed.

Examples may be seen in MacDonalds, where the "Happy" meal exists, where bright colours are used and service must be supportive of the customers needs and thoughts.

7 0
2 years ago
Other questions:
  • Pharoah Company invests $10,400,000 in 5% fixed rate corporate bonds on January 1, 2017. All the bonds are classified as availab
    11·1 answer
  • Carlos owns a hardware store he currently is not using any software to track what he has in the store and wanted to sentences de
    10·1 answer
  • In addition to the legislators and the governor, there are others involved in the lawmaking process during both regular and spec
    5·1 answer
  • Mary is 40 years old, plans to retire at 65 and the actuarial tables tell her she can expect to live until 80. The market value
    10·1 answer
  • BrewCo sells coffeemakers for $120 each. The firm currently has variable costs per unit of $65. If BrewCo is able to reduce its
    13·1 answer
  • A marginal benefit curve has a negative or a positive slope?
    8·1 answer
  • "A registered representative has a long-term client who works in a bank. The representative tells the client that he wants to bu
    8·1 answer
  • Company AA had net income of $20,000 in 2017. Compared to previous year, Accounts Receivable decreased by $10,000, Prepaid Rent
    11·1 answer
  • The data given below are from the accounting records of the Kuhn Corporation:
    10·1 answer
  • What concerns might a gap employee working in one of its stores have because of its social stance?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!