Category: Accounting

NOTE: There are 2 parts to this assignment. First, you will create an Amortization Schedule for a new (or used) vehicle of your choice. The second half of this assignment asks you to create a second amortization schedule for a home, land, or commercial building/land you may be interested in.
Part 1: Vehicle Major Purchases
Using MS Excel, create an amortization schedule for a car loan. There is an Amortization schedule attached to this assignment for you to use for this and the Part 2 portion of this exercise. Fill out the schedule with data using a vehicle purchase you research on the Internet. Use a reasonable price from Kelly Blue Book or from an online “build your own” resource. Make sure you complete the Amortization schedule to completely pay off your vehicle
Note: you will need to highlight the last row and use the pulldown cross in the right corner of the highlighted row to add additional rows until you see your asset paid off completely.
Answer the following Six questions in some detail at the bottom of the same Excel file (see below). Finally, on the last page of the Excel file, answer the following questions by creating a Text box below your Amortization Schedule:
Note iIn excel go to ″Insert″ then ″Text,″ then Create a text box. Create a textbox that is approximately 5″ by 5″. Then copy and paste these questions and then answer in the same textbox):
What is your payment per month?
What is your total paid interest for the term of the loan?
How long is the term for your loan? Why did you choose this term length?
What interest rate did you use AND how did you obtain a legitimate interest rate.
What did you learn from this exercise about incurring debt to purchase this vehicle?
Is this car affordable in your budget at this time?
Part 2: Home, Land, or Commercial Property Major Purchase
Using a second MS Excel spreadsheet, create another amortization schedule for a property you may consider buying some time in the future. Use a reasonable value for the investment by searching with a multiple listing in your area. Next, find a lender that will talk to you and get an interest rate and loan period that they think would be reasonable for each purchase (they will be different). Most, if not all, lenders are willing to help with a project like this, so talk to someone you are familiar with and get them to help with a loan period and interest rate. Make sure you complete the Amortization schedule to completely pay off the property. Finally, on the last page of your excel file, answer the following in some detail in another textbox at the end of your amortization schedule:
Describe what property you are wanting to invest in.
What is a reasonable price for the property and what resource did you use to come to that price?
How much do you want to borrow, and how much are you contemplating as an initial investment (down payment) on the property?
Who did you talk to about an interest rate? How long are you financing the purchase for and what interest have you found a lender would give you?
What is your total paid interest for the term of the loan from the Amortization Schedule?
What have you learned from this exercise?
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

A 250-500 word essay discussing your goals and objectives for pursuing admission to the degree program to which you are applying. 
Please write an essay on why I am interested in pursing a master degree in accounting. MY goals and objectives and what I plan to do what’s I pursue this degree. P

I have attached 6 photos. The first four is basically a background of the company you are doing this case study on and the instructions you will need to fill out the yellow boxes with formulas from the numbers given on the case study. Each box is labeled with a number such as [1] which will mean you need to follow number one of the instruction sheet depending on which part you are at. There are three part and on the instructions it lists what you need to do and that’s when you insert the formulas on the yellow squares. 

you should improve part 3 – there should be tables, figures, calculations of the economic efficiency of your proposals, forecast of company’s indicators for next year’s due to implementation of your proposals, can you please follow this instructions to fix the part 3 and i do need it Asap

Instructions will be uploaded later.
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

All requirements in the attached
similarity should be less than 7% for any clarification plz ask.
Ai is not allowed

Must follow all instructions in attached file titled “project one guidlines & rubric
Must use all attached files to finish excel sheet
Specifically, you must address the following rubric criteria:
Journal Entries Tab
Prepare accurate journal entries with the correct ledger accounts on the Milestone Journal Entries tab of the workbook. Be sure to refer to the Chart of Accounts tab for the account names when preparing journal entries. Include the following details in your response:
Show calculations necessary to prepare the journal entries. Not all journal entries will require a calculation. Rows with an asterisk require formulas in the debit or credit column.
Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Journal Entries tab of the workbook. There are a total of 26 entries.
Inventory Tab
Prepare accurate journal entries with the correct ledger accounts on the Milestone Inventory tab of the workbook.
Prepare the worksheet that reflects the products purchased and sold at the new store on the Milestone Inventory tab of the workbook.
Prepare journal entries that are complete from the transactions listed in Project One Appendix on the Milestone Inventory tab of the workbook. There are a total of 18 entries.

Working papers and supporting calculations must be submitted in a single Word format . Attach references.

The multiple linear regression analysis is one of the most reliable and accurate tools for cost estimating. The validity of the analysis depends on the relevance of the independent variables selected.
Please respond to the following:
Discuss what independent variables you would select to estimate the maintenance costs for a manufacturing company using multiple linear regression analysis.
Explain why you selected these independent variables. What are other variables you considered, but decided not to include in your analysis? Explain why and defend your opinion.

For this module discussion, you are to post an initial response to the topic below of 350-500 words and 1 reply to another student adding new value to the discussion (125-175 words). Initial posts are to be substantive based on reading and research.  Posts are to be unique for each student – not a repeat or paraphrase of what has already been stated. The initial post is due by end of day the Sunday following the chat session.. Reply posts to other students are due the following Sunday. Each module is approximately 2 weeks.  2 posts total during each 2-week period for this discussion.
Please read the article below and discuss implications you may already see or expect in your workplace or a specific field in accounting. You will note that all impact accounting information systems.
https://www.journalofaccountancy.com/newsletters/2017/oct/artificial-intelligence-changing-accounting.html
Need to do a reply to this disscusion with (125-175 word)
1 reply to another student adding new value to the discussion (125-175 words). Initial posts are to be substantive based on reading and research.  Posts are to be unique for each student – not a repeat or paraphrase of what has already been stated.
Discussion from Student
This article discusses the development and progression of AI within the accounting field. Many firms had invested early on to advance their technology, leading to a competitive advantage and increase in their companies’ productivity. AI is taking in and analyzing large volumes of data that no human or team of people would be able to do, which has lead to the automation of less sophisticated job tasks, such as bookkeeping and other data entry positions. Companies can develop and fine-tune their own AI products to produce even more efficient results rather than using a generic AI system. This process can take a lot of resources, like time and money, that many smaller firms may not be able to give, resulting in them being slightly behind the advancements of larger firms, like the Big Four. However, even though it may seem like AI can do anything and everything, humans will still be needed for the more analytic and decision-orientated computations and more sophisticated tasks. 
With all the advantages of implementing and progressing AI in companies, also comes implications within all the fields of accounting. In the field of auditing, companies have already been using AI to automate the examination of financial information based on programming the AI on what to look for. This definitely can make the auditing process more productive and use less time to look through larger amounts of data, but there is certainly a risk with only having the AI evaluate the records. There are many criterion that need to be checked for when auditing, like accuracy, completeness, and compliance with laws and regulations. While an auditor assesses financial information to ensure those things, professional judgement and decision making is also involved, which can be hard to program an AI system to do. Because of this, humans will still be needed to double check the examination is done correctly and to enhance the AI’s results to the clients by providing a detailed analysis of the findings. An implication that can apply to all fields, and other careers besides accounting, is the decrease in the number of entry level job positions offered. Entry level jobs allow for basic skills to develop and a learning environment to then be able to advance through positions. By AI taking on these basic jobs, it serves to ask how new hires will close this gap for themselves to be able to feel like they have the experience they need to move up.