Description
I've attached the word document with the PDF information... Using Excel, prepare the amortization schedule and then record all required journal entries that would be made by Houston and Conroe on the following dates (a) December 31, 2017; (b) December 31, 2018; (c) December 31, 2019; (d December 31, 2020; (e) December 31, 2021; (f) December 31, 2022; (g) December 31, 2023.
Unformatted Attachment Preview
ACC3300 Excel Spreadsheet Project – Summer 2018
On December 31, 2017, Houston Inc. provided consulting services to Conroe Company at an
agreed price of $356,630.79. Houston accepted $75,000 down and agreed to accept the
balance in six equal installments of $60,000 to be received annually on December 31 st,
beginning December, 2018. An assumed interest rate of 7.5% is imputed.
Instructions:
Using Excel, prepare the amortization schedule and then record all required journal entries
that would be made by Houston and Conroe on the following dates (a) December 31,
2017; (b) December 31, 2018; (c) December 31, 2019; (d December 31, 2020; (e)
December 31, 2021; (f) December 31, 2022; (g) December 31, 2023.
You will be assessed on the following skills (1) correct data entered, (2) correct and
accessible formulas, (3) column headings and labels, (4) titles merged and centered, and
(5) spreadsheet formatting and printing.
Purchase answer to see full attachment
Purchase answer to see full attachment
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
Hi, I've uploaded ex...
Completion Status:
100%
Review
Review
Anonymous
Super useful! Studypool never disappoints.
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
University of the District How to Nail a Video Interview Video Analysis
Nailing the InterviewRead “How to Nail a Video Interview" from forbes.com. The link is http://www.forbes.com/sites/chery ...
University of the District How to Nail a Video Interview Video Analysis
Nailing the InterviewRead “How to Nail a Video Interview" from forbes.com. The link is http://www.forbes.com/sites/cherylsnappconner/2013... Reflect on your reading and answer the following questions:1. Why is so important for students like you to know how to "Nail a Video Interview"?2. What is the difference between a video interview and an in-person interview?3. What are the five key considerations the author suggestion you be aware of when preparing for and while participating in a video interview? Which of these were the most surprising to you? How will you prepare for your next video interview?4. What surprised you most about how online interviews are being used? As a result, what is one thing you can do to improve your presentation during an online interview?Practice Your InterviewThe assignment is designed to give each students the opportunity to learn additional tips for answering job interview questions effectively. Use the Interview Simulator (using the link below) to practice interviewing. You are welcomed to each of the simulation areas to prepare, however, every student should complete at least one of the Interview Simulations (blue tab). http://myinterviewsimulator.com/My%20Interview%20Simulator-Online%20Edition/player.htmlNOTE: To ensure that the simulator launches properly, please use either Chrome or Firefox as your browser.After completing the actual simulator (blue tab) reflect on your experience by answering the following questions:Did you practice the basic and behavioral interview questions prior to starting your interview simulation? Did the practice help?How did you feel answering the questions?What did you learn about interviewing?What did you learn about yourself and maybe what you need to do better in an interview?How would you follow up with this interviewer?
Westcliff University Managing Information Technology Research Paper
Questions: Identify the three major types of controls that organizations can use to protect their information resources an ...
Westcliff University Managing Information Technology Research Paper
Questions: Identify the three major types of controls that organizations can use to protect their information resources and provide an example of each one.What is TCP/IP? Explain its layers and how they are used.Discuss the ethical and legal issues related to electronic commerce and provide examples.Apply cloud computing to a known organization and identify the key benefits of it.Describe each phase of the business analytics process.Apply the six common types of electronic commerce to an organization.Discuss the four business decisions that companies must make when they acquire new applications.Instructions-Essay format (APA)-6-7 pages, double spacing-Font: Times New Roman-At least 6 peer reviewed sources (include DOI in reference page)-In text citations for each peer-reviewed source-No plagiarism
7 pages
Malala 123
Please carefully read the case study on Canvas. You may make reasonable assumptions if information is not provided. You MU ...
Malala 123
Please carefully read the case study on Canvas. You may make reasonable assumptions if information is not provided. You MUST explain your assumptions ...
CS165 Grantham University Week 3 Preparing a Personal Budget Discussion
Week 3 Discussion
Advanced Microcomputer Applications
Week 3 Discussion One ...
CS165 Grantham University Week 3 Preparing a Personal Budget Discussion
Week 3 Discussion
Advanced Microcomputer Applications
Week 3 Discussion One of the most commonly used function in spreadsheets is the SUM function that you are are reading about this week. Describe a scenario where you could personally use the SUM function in a worksheet and briefly discuss what factors you would consider in deciding to take the time to set up SUM functions in a spreadsheet vs. just manually updating totals with a calculator. Additionally, submit an Excel or Google Sheets attachment that contains a column of at least 3 values and with a Total row at the bottom that uses the SUM function to add those cells. To better showcase your data, look to label your values in a column to the left and label your Total row as well. Feel free to get creative with formatting, the kind of numerical values you are adding, and your subject matter. (Remember: do not include any personal data for you or friends/family in these submissions) Week 4 Discussion
Advanced Microcomputer Applications
Week 4 Discussion Both Excel and Google Sheets allow the user to add additional worksheet tabs to allow for multiple sheets within one larger workbook. Give an example from your personal or professional life where it might be necessary to create a workbook with multiple tabs. Are there any potential challenges or disadvantages to maintaining several tabs in one worksheet vs. keeping several separate files? Additionally, using your Week 3 discussion submission attachment (your spreadsheet using the SUM function), create two new tabs (to give you a total of 3 sheets). Rename each sheet to a theme of your choice, but something that makes sense when used together (such as tabs for three different client payment logs in your landscaping business). Also, change the colors of each tab to be unique from each other. The workbook should contain data on the original sheet from your prior submission, but otherwise, just focus on the work for the worksheet tabs. You do NOT need to create new data for all three pages. Submit the spreadsheet as an attachment so others can see what you have done and comment on your work. Be sure to use your own sheet tab names and not those that others have used.
Similar Content
Comprehensive Strategic Plan, business and finance homework help
Please see attached document for assignment details....
Project Management
9 simple basic questions Project Management most of them true and False and two basic, short questions . Thank you ...
GWU University CFA Program Level I on Understanding Balance Sheets Summary
Summarize the CFA Level II reading Understanding Balance Sheets (attached)...
Central Virginia Community Development of the Debt Market in Saudi Discussion
Define the Saudi Debt Market. Is the Market active in the recent period?
What are the prospect and the challenges of the...
Human Resource Management
In what ways would the type of degree you are pursuing (Human Resource Management Degree research study) impact the way yo...
Management Question
...
Business Law
In accordance with the Securities and Futures Ordinance, both Kenny and Cheryl have participated in insider trading activi...
Discussion Quebecor Printing
Quebecor Printing Company ought to primarily realize the unremitting development in operative effectiveness that is critic...
Smart Objective
The recent climatic changes experiences in California especially the severe thunderstorms have increases the chances of a ...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
University of the District How to Nail a Video Interview Video Analysis
Nailing the InterviewRead “How to Nail a Video Interview" from forbes.com. The link is http://www.forbes.com/sites/chery ...
University of the District How to Nail a Video Interview Video Analysis
Nailing the InterviewRead “How to Nail a Video Interview" from forbes.com. The link is http://www.forbes.com/sites/cherylsnappconner/2013... Reflect on your reading and answer the following questions:1. Why is so important for students like you to know how to "Nail a Video Interview"?2. What is the difference between a video interview and an in-person interview?3. What are the five key considerations the author suggestion you be aware of when preparing for and while participating in a video interview? Which of these were the most surprising to you? How will you prepare for your next video interview?4. What surprised you most about how online interviews are being used? As a result, what is one thing you can do to improve your presentation during an online interview?Practice Your InterviewThe assignment is designed to give each students the opportunity to learn additional tips for answering job interview questions effectively. Use the Interview Simulator (using the link below) to practice interviewing. You are welcomed to each of the simulation areas to prepare, however, every student should complete at least one of the Interview Simulations (blue tab). http://myinterviewsimulator.com/My%20Interview%20Simulator-Online%20Edition/player.htmlNOTE: To ensure that the simulator launches properly, please use either Chrome or Firefox as your browser.After completing the actual simulator (blue tab) reflect on your experience by answering the following questions:Did you practice the basic and behavioral interview questions prior to starting your interview simulation? Did the practice help?How did you feel answering the questions?What did you learn about interviewing?What did you learn about yourself and maybe what you need to do better in an interview?How would you follow up with this interviewer?
Westcliff University Managing Information Technology Research Paper
Questions: Identify the three major types of controls that organizations can use to protect their information resources an ...
Westcliff University Managing Information Technology Research Paper
Questions: Identify the three major types of controls that organizations can use to protect their information resources and provide an example of each one.What is TCP/IP? Explain its layers and how they are used.Discuss the ethical and legal issues related to electronic commerce and provide examples.Apply cloud computing to a known organization and identify the key benefits of it.Describe each phase of the business analytics process.Apply the six common types of electronic commerce to an organization.Discuss the four business decisions that companies must make when they acquire new applications.Instructions-Essay format (APA)-6-7 pages, double spacing-Font: Times New Roman-At least 6 peer reviewed sources (include DOI in reference page)-In text citations for each peer-reviewed source-No plagiarism
7 pages
Malala 123
Please carefully read the case study on Canvas. You may make reasonable assumptions if information is not provided. You MU ...
Malala 123
Please carefully read the case study on Canvas. You may make reasonable assumptions if information is not provided. You MUST explain your assumptions ...
CS165 Grantham University Week 3 Preparing a Personal Budget Discussion
Week 3 Discussion
Advanced Microcomputer Applications
Week 3 Discussion One ...
CS165 Grantham University Week 3 Preparing a Personal Budget Discussion
Week 3 Discussion
Advanced Microcomputer Applications
Week 3 Discussion One of the most commonly used function in spreadsheets is the SUM function that you are are reading about this week. Describe a scenario where you could personally use the SUM function in a worksheet and briefly discuss what factors you would consider in deciding to take the time to set up SUM functions in a spreadsheet vs. just manually updating totals with a calculator. Additionally, submit an Excel or Google Sheets attachment that contains a column of at least 3 values and with a Total row at the bottom that uses the SUM function to add those cells. To better showcase your data, look to label your values in a column to the left and label your Total row as well. Feel free to get creative with formatting, the kind of numerical values you are adding, and your subject matter. (Remember: do not include any personal data for you or friends/family in these submissions) Week 4 Discussion
Advanced Microcomputer Applications
Week 4 Discussion Both Excel and Google Sheets allow the user to add additional worksheet tabs to allow for multiple sheets within one larger workbook. Give an example from your personal or professional life where it might be necessary to create a workbook with multiple tabs. Are there any potential challenges or disadvantages to maintaining several tabs in one worksheet vs. keeping several separate files? Additionally, using your Week 3 discussion submission attachment (your spreadsheet using the SUM function), create two new tabs (to give you a total of 3 sheets). Rename each sheet to a theme of your choice, but something that makes sense when used together (such as tabs for three different client payment logs in your landscaping business). Also, change the colors of each tab to be unique from each other. The workbook should contain data on the original sheet from your prior submission, but otherwise, just focus on the work for the worksheet tabs. You do NOT need to create new data for all three pages. Submit the spreadsheet as an attachment so others can see what you have done and comment on your work. Be sure to use your own sheet tab names and not those that others have used.
Earn money selling
your Study Documents