Writer Choice
43044I I have attached the excel spreadsheets assignments and other assignments at the end of this page that coincides with the excel spreadsheets. I attached the spreadsheet that you need to continue with each assignment. I also attached all information needed to acccess quickbooks and my text book. Just like you did for Module 1.
Module 02 Assignment – QuickBooks Exercises
In the Computer Accounting with QuickBooks Online textbook, complete and submit the following:
Chapter 3: Complete the chapter readings and activities. Complete Exercise 3-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (10/01/2018 – 10/30/2018)
Trial Balance (10/01/2018 – 10/30/2018)
Profit & Loss (10/01/2018 – 10/30/2018)
Balance Sheet (10/01/2018 – 10/30/2018)
Chapter 4: Complete the chapter readings and activities. Complete Exercise 4-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (10/01/2018 – 11/12/2018)
Trial Balance (10/01/2018 – 11/12/2018)
Profit & Loss (10/01/2018 – 11/12/2018)
Balance Sheet (10/01/2018 – 11/12/2018)
Inventory Valuation Summary (10/01/2018 – 11/12/2018)
Vendor Balance Summary (10/01/2018 – 11/12/2018)
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 03 Assignment – QuickBooks Exercises
Chapter 5: Complete the chapter readings and activities. Complete Exercise 5-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (11/13/2018 – 12/01/2018)
Trial Balance (10/01/2018 – 12/01/2018)
Profit & Loss (10/01/2018 – 12/01/2018)
Balance Sheet (10/01/2018 – 12/01/2018)
Inventory Valuation Summary (10/01/2018 – 12/01/2018)
Vendor Balance Summary (10/01/2018 – 12/01/2018)
Customer Balance Summary (10/01/2018 – 12/01/2018)
Chapter 6: Complete the chapter readings and activities. Complete Exercise 6-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (12/31/2018 – 12/31/2018)
Trial Balance (10/01/2018 – 12/31/2018)
Profit & Loss (10/01/2018 – 12/31/2018)
Balance Sheet (10/01/2018 – 12/31/2018)
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 04 Assignment – QuickBooks Exercises
In the Computer Accounting with QuickBooks Online textbook, complete and submit the following:
Chapter 7: Complete the chapter readings and activities. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (12/31/18-12/31/18)
Adjusted Trial Balance (10/01/18-12/31/18)
Profit & Loss (10/01/18-12/31/18)
Balance Sheet Dec 31 (10/01/18-12/31/18)
Balance Sheet Jan 1 (10/01/18-01/01/19)
Post Closing Trial Balance (10/01/18-01/01/19)
Chapter 8: Complete the chapter readings and activities. Complete Exercise 8-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (01/31/2019 – 01/31/2019)
Trial Balance (01/01/2019 – 01/31/2019)
Profit & Loss (01/01/2019 – 01/31/2019)
Balance Sheet (01/01/2019 – 01/31/2019)
Inventory Balance Summary (01/01/19 – 01/31/19)
Vendor Balance Summary (01/01/19 – 01/31/2019)
Customer Balance Summary (01/01/19 – 01/31/2019)
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 05 Assignment – QuickBooks Exercises
In the Computer Accounting with QuickBooks Online textbook, complete and submit the following:
Chapter 9: Complete the chapter readings and activities. Complete Exercise 9-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (02/28/19 – 02/28/19)
Trial Balance (01/01/2019 – 02/28/2019)
Profit & Loss (01/01/2019 – 02/28/2019)
Balance Sheet (01/01/2019 – 02/28/2019)
Inventory Balance Summary (01/01/19 – 02/28/19)
Vendor Balance Summary (01/01/19 – 02/28/2019)
Customer Balance Summary (01/01/19 – 02/28/2019)
Case Problem 1: Work through the case problem readings and activities. Submit the following screenshot, inserted on a tab in a single Microsoft Excel file.
Screen shot of the journal entry for check number 77 for Kari Steblay
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 06 Assignment – QuickBooks Exercises
In the Computer Accounting with QuickBooks Online textbook, complete and submit the following:
Chapter 10: Complete the chapter readings and activities. Complete Exercise 10-1. Submit the following reports for the dates given, exported to a single Microsoft Excel file, with each report on its own tab:
Journal (3/31/2019 – 3/31/2019)
Trial Balance (01/01/2019 – 03/31/2019)
Profit & Loss (01/01/2019 – 03/31/2019)
Balance Sheet (01/01/2019 – 03/31/2019)
Inventory Balance Summary (01/01/19 – 03/31/19)
Vendor Balance Summary (01/01/2019 – 03/31/2019)
Customer Balance Summary (01/01/2019 – 03/31/2019)
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Save your assignment as a Microsoft Excel document. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:
Jstudent_exampleproblem_101504
Module 04 Course Project – Twelve Month Pro Forma Budgeted Income Statement (YOU HAVE THE EXCEL SPREADSHEET FOR THE INFO FOR THIS ASSIGNMENT)
Considering your Cloud Ware Company, compare the November ending Profit and Loss Statement with the end of December Profit and Loss statement. This work should be done in Excel.
Compare the November Balance Sheet with the balance sheet as of December 31st. After analyzing the statements, answer the following questions:
What is the financial situation of the company as of November 30?
Did the financial situation improve, remain the same, or start to decline through the month of December?
What areas of strength exist in the company? What are the company’s weaknesses?
What are some areas where the company has opportunities for growth for the company’s financial situation?
To help you justify the above answers, financial ratios should be calculated. At minimum, the following ratios should be calculated and used to support your arguments:
Debt to Equity Ratio (Total Liabilities/Equity) This ratio provides a look at how much the creditors have put into the company compared to how much the owners have put into the company.
Current Ratio (Current Assets/Current Liabilities) This provides a look at whether the business has enough current assets to pay their current liabilities.
Profit Margin (Net Income/Sales) This provides a measure of how much profit is earned on each dollar of sales.
You have decided to request a bank loan to expand your Cloud Ware business and the lender has asked for a one-year projection of revenue and expenses. To request the loan, you will need to create a Pro Forma one year budgeted income statement broken down over 12 months. You will need to look at the actual ending financial statements for October, November, and December and use this data to help create the forecast for the next fiscal year of business.
Using financial ratios will be critical in supporting your argument for the loan and be aware that most bankers or lenders will not even consider a loan prospect without addressing, for example, the impact of additional debt on your debt to equity ratio.
Note: Excel must be used for creating the analysis and budget and must include formulas for all mathematical calculations including adding, subtracting and sums of columns or groups of cells.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Module 05 Course Project – Presentation to Lender ( YOU HAVE THE INFO AND SPREADSHEET FOR THIS ASSIGNMENT)
Analyze the pro forma statements and analysis created in the previous module and create a detailed PowerPoint presentation with speaker’s notes to demonstrate why the bank should give your company a loan. The amount requested and loan terms should be financially manageable and you need to justify the amount requested in your presentation. Your presentation should include:
A clear explanation of how much money is being requested from the lender and how the money will be used to expand the business.
General explanation of the business; who are the customers, where is it located, how long has it been in existence, etc.
An overview of the 12 Month Pro Forma Budgeted Income Statement created in the previous module with ratios.
An analysis of the year end income statement that includes key financial ratios.
An overview of the financial strengths and weaknesses of the company and an explanation of how those elements will be leveraged and minimized to ensure that the loan will be a good solid investment and financially manageable. Make sure to use financial ratios to support your argument and help sell this idea to the lender.
Finally, keep in mind that the audience of this presentation will be the lender and that the goal of this presentation is to sell the Cloud Ware company as a good investment to the potential lender.
See the Writing Guide for additional guidance on Power Point presentations and Course Projects.
Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
