Description
Hello! This week chapter 8 is due. Chapter 8 homework and also chapter 8 test. Both are due in 2 days. Thank you!
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Southwestern College Computer Applications Travel Balance Memo
Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the ...
Southwestern College Computer Applications Travel Balance Memo
Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the travelers that have a balance due greater than or equal to $2000. In doing so, be sure to address the following requirements:Open a new Microsoft Word document. In the search box, run a search for the Professional Design Memo Template.Update the Company Name to International Travel Company.Update the values in the To, CC, From, and Date fields.Update the Re: to be Statistics from Recent Balance Due InquiryThe title of your template should be Travelers with >=$2000 Balance Due (Note: there is NO title place holder. Put the title under the Re: line)In the body of the memo, include a short explanation of the details that you are providing to your employer.Integrate the PivotTable that you created into the Memo as a Microsoft Excel object. (Do not create a link).HINT: when you double click the pivot table, you should get a mini copy of Excel.Save the Word document using the correct naming convention.
Retirement Accounts, writing homework help
EX16_AC_CH03_GRADER_CAP_AS - Retirement Accounts Project Description: One-Stop Finance is a company that works w ...
Retirement Accounts, writing homework help
EX16_AC_CH03_GRADER_CAP_AS - Retirement Accounts Project Description: One-Stop Finance is a company that works with Clients in all areas of finance. They assist with banking, financial planning, mortgages, stock, insurance, retirement counseling, and debt consolidation. Cala Hamieh, one of the senior planners for the company, is hoping to extract information from the database. The company has a large database with hundreds of thousands of accounts, but to allow you to rapidly test your queries, you have created a smaller version of the database with a small amount of clients. Once you are confident your queries work, you can import them in to the main Access database. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named exploring_a03_Grader_a1.accdb. 0 2 Create a query using Query Design. From the Clients table, display the client’s First and LastName. From the Accounts table, select the Savings Balance and OpenDate. Sort the query by savings balance in descending order. 5 3 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. 10 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. 10 5 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. 10 6 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. 10 7 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. 10 8 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. 10 9 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. 10 10 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. 15 11 Change the format of the LoanPayment field to Currency. Change the caption to Loan Payment. Save the query as Monthly Loan Payments and close the query. 10 12 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0 Total Points 100
FIN 501 Trident University Calculate the Compound Interest Case Study
mail_outlinenotificationsaccount_balancesearchJasonValeroPresent your answers to the problem below in a Word document, and ...
FIN 501 Trident University Calculate the Compound Interest Case Study
mail_outlinenotificationsaccount_balancesearchJasonValeroPresent your answers to the problem below in a Word document, and also upload an Excel file with your computations. Excel is required for Questions 2 and 3. Excel is optional for Questions 1 and 4, but you are required to show your steps for all quantitative problems. Even if you get the answer wrong, you can still get partial credit if you show your work.Calculate the following:Suppose you wish to raise some money for your favorite local charity. This charity needs $50,000 a year to run its operation and you want to make sure that it is ensured an annual payment of this amount from now on for every year in the foreseeable future. Given an interest rate of 5%, how much would you have to fund this perpetuity to guarantee the charity a payment of $50,000 per year?You decide to put $1,000 in a new bank account and don’t plan to withdraw the money for 10 years. If your bank does continuous compounding and the interest rate is 1%, what will be the value of this bank account in 10 years?Suppose you won the lottery but not all of your winnings will come in one year. Instead, you will get a series of annual payments over the next five years. The table below tells you what your payment will be every year for the next five years. Use the information in the table to make the following computations:The present and future value of your lottery ticket if the interest rate is 8%The present and future value of your lottery ticket if the interest rate is 10%YearPayment1500026000370004800059000The table below gives the probability of different returns for three different assets. Using this table, calculate the following:The expected return of each assetThe standard deviation of returns of each assetThe coefficient of variation of each assetBased on your answers to B) and C) above, which asset has the highest total risk and highest relative risk?Asset AAsset BAsset CProbabilityReturnProbabilityReturnProbabilityReturn0.350.1250.140.480.3200.850.390.5150.160.114Suppose the market return is 8%, the risk-free rate is 1% and the beta for a given stock is 1.2. Answer the following questions based on this information:What is the required return for this stock?If the beta increases by 50% (but risk-free rate remains 1%), what will be the new required return for the stock? What is the percentage-wise change in required return compared to your answer to A) above?If the market return increases by 50% (but beta remains at 1.2), what will be the new required return for the stock? What is the percentage-wise change in required return compared to your answer to A) above?Suppose there are three different companies. The first one, Trendy Tech Inc., has investors who are “fair-weather friends.” When the stock market is going up, everybody wants to invest in Trendy Tech, but as soon as the market goes down everyone jumps ships and sells their shares. The second company is Oily Oil Inc. Oily’s stock price seems to depend only on the price of oil and nothing else. Finally, there is Conglomerated Conglomerate Inc. Conglomerated is a giant company with holdings in almost every industry imaginable—from cell phones to grocery stores and even amusement parks. Based on this information, which company would you think has the highest beta? The lowest beta? Which one do you think has a beta closest to 1?
9 pages
Research On Current And Emerging Technologies Focusing On Aenergy Company
Research on Current and Emerging Technologies Focusing on Aenergy Company Research on Current and Emerging Technologies Fo ...
Research On Current And Emerging Technologies Focusing On Aenergy Company
Research on Current and Emerging Technologies Focusing on Aenergy Company Research on Current and Emerging Technologies Focusing on Aenergy Company
8 pages
Tata Starbucks Case Study
Market: Why does Starbucks want to enter the India market? Starbucks is an American multinational business that boasts of ...
Tata Starbucks Case Study
Market: Why does Starbucks want to enter the India market? Starbucks is an American multinational business that boasts of a strong chain of
SEU Module 5 Management Cybersecurity and Risk Management Discussion
Consider your organization or another organization that has been affected by a cyber-attack. Feel free to research current ...
SEU Module 5 Management Cybersecurity and Risk Management Discussion
Consider your organization or another organization that has been affected by a cyber-attack. Feel free to research current events on this topic if you do not have personal experience with an organization who has been affected by a cyber-attack. Once you have selected an organization, answer the following questions:
Provide a brief summary of the organization you have selected.
What type of cyber-attack occurred?
How did the organization respond to the attack?
What were the impacts (or potential impacts) to the business?
What were the costs associated with the attack? If you do not have actual numbers, what types of costs were likely involved?
What did the organization do to mitigate the risk of future attacks? Did the organization change its processes or procedures?
As a business manager, what are some additional recommendations you would make to the organization, from a business perspective, to better defend itself in the future? What steps can the business take to better support the IT (information technology) department’s security efforts? Explain.
Similar Content
.Several internal and external assessment methods, management homework help
1.Several internal and external assessment methods were discussed within this unit. Identify and discuss three internal as...
week 7 discussion and reply to 2 students
Discussion 7: Regulating the InternetThe regulation of business and individual behavior over the Internet is a controversi...
Tallahassee Community College Ahmed Assafs Candy and Corns Sales Invoice Excel Task
All details and instructions will be on the pdf itself. It is a guidance to what is supposed to be done in the excel....
Arizona State University CH15&17 Bayonne Packaging Inc Business Case Study
See attached for the case study on Bayonne
Packaging. Use a few references from the textbook (link below). Use Chapters 1...
MGT 4471 Troy University Effective Leadership Discussion
Each deliverable must be accompanied by a minimum of 2 documented sources (limited to the textbook and one additional acad...
Ethical Behavior Questionnaire
Why does ethical behavior matters so much in public service? Who is responsible for ethical behavior in an organization? W...
Case Study
GoTech is a Saudi company (located in Riyadh) that provides technical and digital solutions to other businesses and indivi...
Fdi Foreign Direct Investment And Ease Of Doing Business
Nations have different rules, regulation, and policies that govern how business is conducted as well who can invest in the...
System And Structure
Change efforts, along with the strategy and culture of an organization as a whole, may be impacted by its underlying syste...
Related Tags
Book Guides
Shattered - Inside Hillary Clintons Doomed Campaign
by Amie Parnes and Jonathan Allen
Sounds Like Titanic
by Jessica Chiccehito Hindman
The Woman in the Window
by A. J. Finn
The 48 Laws of Power
by Robert Greene
Jane Eyre
by Charlotte Brontë
The Good Earth
by Pearl S. Buck
Big Little Lies
by Liane Moriarty
Milkweed
by Jerry Spinelli
The Prince
by Niccolò Machiavelli
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Southwestern College Computer Applications Travel Balance Memo
Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the ...
Southwestern College Computer Applications Travel Balance Memo
Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the travelers that have a balance due greater than or equal to $2000. In doing so, be sure to address the following requirements:Open a new Microsoft Word document. In the search box, run a search for the Professional Design Memo Template.Update the Company Name to International Travel Company.Update the values in the To, CC, From, and Date fields.Update the Re: to be Statistics from Recent Balance Due InquiryThe title of your template should be Travelers with >=$2000 Balance Due (Note: there is NO title place holder. Put the title under the Re: line)In the body of the memo, include a short explanation of the details that you are providing to your employer.Integrate the PivotTable that you created into the Memo as a Microsoft Excel object. (Do not create a link).HINT: when you double click the pivot table, you should get a mini copy of Excel.Save the Word document using the correct naming convention.
Retirement Accounts, writing homework help
EX16_AC_CH03_GRADER_CAP_AS - Retirement Accounts Project Description: One-Stop Finance is a company that works w ...
Retirement Accounts, writing homework help
EX16_AC_CH03_GRADER_CAP_AS - Retirement Accounts Project Description: One-Stop Finance is a company that works with Clients in all areas of finance. They assist with banking, financial planning, mortgages, stock, insurance, retirement counseling, and debt consolidation. Cala Hamieh, one of the senior planners for the company, is hoping to extract information from the database. The company has a large database with hundreds of thousands of accounts, but to allow you to rapidly test your queries, you have created a smaller version of the database with a small amount of clients. Once you are confident your queries work, you can import them in to the main Access database. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named exploring_a03_Grader_a1.accdb. 0 2 Create a query using Query Design. From the Clients table, display the client’s First and LastName. From the Accounts table, select the Savings Balance and OpenDate. Sort the query by savings balance in descending order. 5 3 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. 10 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. 10 5 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. 10 6 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. 10 7 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. 10 8 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. 10 9 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. 10 10 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. 15 11 Change the format of the LoanPayment field to Currency. Change the caption to Loan Payment. Save the query as Monthly Loan Payments and close the query. 10 12 Close all database objects. Close the database and then exit Access. Submit the database as directed. 0 Total Points 100
FIN 501 Trident University Calculate the Compound Interest Case Study
mail_outlinenotificationsaccount_balancesearchJasonValeroPresent your answers to the problem below in a Word document, and ...
FIN 501 Trident University Calculate the Compound Interest Case Study
mail_outlinenotificationsaccount_balancesearchJasonValeroPresent your answers to the problem below in a Word document, and also upload an Excel file with your computations. Excel is required for Questions 2 and 3. Excel is optional for Questions 1 and 4, but you are required to show your steps for all quantitative problems. Even if you get the answer wrong, you can still get partial credit if you show your work.Calculate the following:Suppose you wish to raise some money for your favorite local charity. This charity needs $50,000 a year to run its operation and you want to make sure that it is ensured an annual payment of this amount from now on for every year in the foreseeable future. Given an interest rate of 5%, how much would you have to fund this perpetuity to guarantee the charity a payment of $50,000 per year?You decide to put $1,000 in a new bank account and don’t plan to withdraw the money for 10 years. If your bank does continuous compounding and the interest rate is 1%, what will be the value of this bank account in 10 years?Suppose you won the lottery but not all of your winnings will come in one year. Instead, you will get a series of annual payments over the next five years. The table below tells you what your payment will be every year for the next five years. Use the information in the table to make the following computations:The present and future value of your lottery ticket if the interest rate is 8%The present and future value of your lottery ticket if the interest rate is 10%YearPayment1500026000370004800059000The table below gives the probability of different returns for three different assets. Using this table, calculate the following:The expected return of each assetThe standard deviation of returns of each assetThe coefficient of variation of each assetBased on your answers to B) and C) above, which asset has the highest total risk and highest relative risk?Asset AAsset BAsset CProbabilityReturnProbabilityReturnProbabilityReturn0.350.1250.140.480.3200.850.390.5150.160.114Suppose the market return is 8%, the risk-free rate is 1% and the beta for a given stock is 1.2. Answer the following questions based on this information:What is the required return for this stock?If the beta increases by 50% (but risk-free rate remains 1%), what will be the new required return for the stock? What is the percentage-wise change in required return compared to your answer to A) above?If the market return increases by 50% (but beta remains at 1.2), what will be the new required return for the stock? What is the percentage-wise change in required return compared to your answer to A) above?Suppose there are three different companies. The first one, Trendy Tech Inc., has investors who are “fair-weather friends.” When the stock market is going up, everybody wants to invest in Trendy Tech, but as soon as the market goes down everyone jumps ships and sells their shares. The second company is Oily Oil Inc. Oily’s stock price seems to depend only on the price of oil and nothing else. Finally, there is Conglomerated Conglomerate Inc. Conglomerated is a giant company with holdings in almost every industry imaginable—from cell phones to grocery stores and even amusement parks. Based on this information, which company would you think has the highest beta? The lowest beta? Which one do you think has a beta closest to 1?
9 pages
Research On Current And Emerging Technologies Focusing On Aenergy Company
Research on Current and Emerging Technologies Focusing on Aenergy Company Research on Current and Emerging Technologies Fo ...
Research On Current And Emerging Technologies Focusing On Aenergy Company
Research on Current and Emerging Technologies Focusing on Aenergy Company Research on Current and Emerging Technologies Focusing on Aenergy Company
8 pages
Tata Starbucks Case Study
Market: Why does Starbucks want to enter the India market? Starbucks is an American multinational business that boasts of ...
Tata Starbucks Case Study
Market: Why does Starbucks want to enter the India market? Starbucks is an American multinational business that boasts of a strong chain of
SEU Module 5 Management Cybersecurity and Risk Management Discussion
Consider your organization or another organization that has been affected by a cyber-attack. Feel free to research current ...
SEU Module 5 Management Cybersecurity and Risk Management Discussion
Consider your organization or another organization that has been affected by a cyber-attack. Feel free to research current events on this topic if you do not have personal experience with an organization who has been affected by a cyber-attack. Once you have selected an organization, answer the following questions:
Provide a brief summary of the organization you have selected.
What type of cyber-attack occurred?
How did the organization respond to the attack?
What were the impacts (or potential impacts) to the business?
What were the costs associated with the attack? If you do not have actual numbers, what types of costs were likely involved?
What did the organization do to mitigate the risk of future attacks? Did the organization change its processes or procedures?
As a business manager, what are some additional recommendations you would make to the organization, from a business perspective, to better defend itself in the future? What steps can the business take to better support the IT (information technology) department’s security efforts? Explain.
Earn money selling
your Study Documents