LEARN MORE...

Np Ex19 9a Chinedumbamalu 2

Content type

User Generated

Subject

Excel

School

Texas Wesleyan University

Type

Homework

Uploaded By

oelnar7200

Pages

11

Showing Page:

1/11

Sign up to view the full document!

Showing Page:

2/11

Sign up to view the full document!

Showing Page:

3/11

Sign up to view the full document!

End of Preview - Want to read all 11 pages?

Unformatted Attachment Preview

Author: Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. New Perspectives Excel 2019 | Module 9: SAM Project 1a Mount Moreland Hospital PERFORM FINANCIAL CALCULATIONS Chinedu Mbamalu Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. py of the file Mount Moreland Hospital - Neighborhood Nurse Van Loan Conditions and Payments Conditions Loan amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan Equipped Van $234.000 4,35% 0,36% 5 60 ($4.347) 1/4/2022 Months Annual Principal and Cumulative Interest Payments Year 1 Year 2 Interest Principal Principal remaining Remaining % Year 3 1 13 25 12 24 36 ($7.431) ($44.727) $146.447 62,6% ($5.446) ($46.712) $99.735 42,6% ($9.332) ($42.826) $191.174 81,7% od Nurse Van Year 4 Year 5 37 49 48 60 ($3.373) ($48.785) $50.950 21,8% ($1.208) ($50.950) ($0) 0,0% Total ($26.791) ($234.000) Mount Moreland Hospital - Neighborhood Nurse Van Depreciation Van with Medical Equipment Long-term assets (cost) Salvage value (salvage) Life of asset (life) Straight-Line Depreciation Year Annual depreciation Cumulative depreciation Depreciated asset value $ $ 234.000 37.440 7 1 $28.080 $28.080 $205.920 2 $28.080 $56.160 $177.840 3 $28.080 $84.240 $149.760 4 $28.080 $1 ...
Purchase document to see full attachment

Tags: health and medical excel sheet excel assignment Mount Moreland Hospital Neighborhood Nurse Van

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Studypool

4.7

Indeed

4.5

Sitejabber

4.4

24/7 Study Help

Stuck on a study question? Our verified tutors can answer all questions, from basic math to advanced rocket science!

Post question

PSC495 Grand Canyon University Problem Solutions Matrix Research Paper

Minimum 100 word response and if sources are used - cited. No format needed Question 1: In many projects, teams are ...

PSC495 Grand Canyon University Problem Solutions Matrix Research Paper

Minimum 100 word response and if sources are used - cited. No format needed Question 1: In many projects, teams are tempted to immediately identify solutions for implementation. Explain why is important to follow a process for understanding the problem, and who should be involved in final solution prioritization. Questions 2: On the "Problem Solutions Matrix," handout, the category "Customer Importance" received twice the weight of all other categories. Using what you learned from the Topic Materials, discuss the relative importance of this criterion. Discuss whether you think this weighting was appropriate, and explain why. Discuss whether there are additional criteria that should have had greater weight and explain why.

GCC A Rejection of Your Wedding Date Request Email & Discussion

Hello Class -To follow are instructions and a prompt for your SECOND GRADED WRITTEN ASSIGNMENT. It is based on chapter 7 a ...

GCC A Rejection of Your Wedding Date Request Email & Discussion

Hello Class -To follow are instructions and a prompt for your SECOND GRADED WRITTEN ASSIGNMENT. It is based on chapter 7 and entitled Radical Rewrite: Request Refusal—Nuptials Nixed at Napa Inn The below poorly written letter turns down the request of a bride-to-be seeking to reserve the popular Napa Valley Inn as a venue for her wedding.How can this letter be made less disappointing?Your Task. Analyze the message.List its weaknesses and what information is missing, thenOutline an appropriate writing plan. NEXT, use your analysis and REWRITE the letter, which you will submit via this assignment link. NOTE: You are NOT to answer the letter. Only rewrite to make it grammatically and stylistically correct. So, in a Word document you will outline the following:1) weaknesses you found in the document (in bullets)2) a brief strategy of how to rewrite the letter (two or three paragraphs)3) and the actual revised and final draft of your letter (your own version of the document)NOTE your letter should follow the exact same format that that is discussed in the textbook- i.e. Sender's and Receiver's full information, date, subject, salutation, intro., body, appropriate number of words per line and lines per paragraphs, etc.I strongly encourage you to refer to your textbook and as often as needed. Also, review my notes on your previously submitted and graded written assignments #1 ------look for detail on what I asked you to specifically improve on. Be as creative as you like both in your writing and the aesthetics of the letter. You will be replying as if you are the VP of Operations for the Napa Valley Inn. The use of fictitious (fake) dates and addresses is completely acceptable. Enjoy and make this learning experience count!++++++++++++BELOW IS THE MESSAGE/LETTER YOU NEED TO ANALYZE AND REWRITE ++++++++++Current dateMs. Sonya Capretta2459 Sierra AvenueFresno, CA 93710Dear Ms. Capretta:We regret to inform you that the wedding date you request in your letter of February 2 at the Napa Valley Inn is unavailable. Unfortunately, we are fully booked for all of the Saturdays in June, as you probably already suspected.June is our busiest month, and smart brides make their reservations many months—even years—in advance. That’s because the Napa Valley Inn is the ideal romantic getaway for weddings. With unparalleled cuisine and service, along with panoramic Napa Valley and vineyard views, our inn offers a unique, intimate ambiance in a breathtaking location for your special event.We apologize if we have caused you any inconvenience. However, if you could change your wedding date to the middle of the week, we would try to accommodate your party. We do have a few midweek spots open in June, but even those dates are rapidly filling up. With 45 Mediterranean-style rooms and suites, each with its own sunny private terrace, the Napa Valley Inn is the perfect location for you and your partner to begin your married lives. Afternoon ceremonies typically begin at 11 a.m., while golden sunsets at the Napa Valley Inn offer a romantic prelude of the evening to come. Evening ceremonies usually begin at 6 p.m. I’m available if you want to arrange something.Sincerely,[Your Name - title]

USF Financial Sheet Cash Flow Paper

check the file plzThe following events apply to your company’s first year of operations:January 1, 2020 - Acquired $20,0 ...

USF Financial Sheet Cash Flow Paper

check the file plzThe following events apply to your company’s first year of operations:January 1, 2020 - Acquired $20,000 cash from the issue of common stock.January 1, 2020 - Purchased $800 of supplies on account.January 1, 2020 – Purchased a truck for $10,000 cash. Salvage value is $2,000. Useful life is 4 years. January 15, 2020 - Paid $4,200 cash in advance for a one-year lease on office space starting February 1, 2020.March 31, 2020 - Earned $28,000 of revenue on account.March 31, 2020 - Incurred $12,500 of other operating expenses on account.March 31, 2020 - Collected $24,000 cash from accounts receivable.March 31, 2020 - Paid $9,000 cash on accounts payable.April 1, 2020 borrowed $10,000 from the bank on a 6 month Note Payable with a 10% interest rate. June 30, 2020 Paid a $3,000 cash dividend to the stockholders.The Stockholders would like to see how your company is performing in the first 6 months of operation and have asked for a complete set of Financial Statements for the period 01/01/2020 – 06/30/2020. Prepare the period end adjusting journal entries noted below, but keep in mind this is for 6 months of operation. Information for Adjusting Entries – all should be dated June 30, 2020.There was $150 of supplies on hand at the end of June 2020.The lease on the office space covered a one-year period beginning February 1, 2020.There was $3,600 of accrued salaries at the end of the period.Your company estimates uncollectable accounts receivable as 1% of sales on account. (You may have to choose a “customer” for your entry. Select “Complete Business Service” or another option that will allow you to post the journal entry.)Record Depreciation on the truck purchased on January 1, 2020.Record interest expense for the Note Payable dated April 1, 2020. Interest will be paid when the note is due.Once the events above are recorded, check the total debits/credits on your Journal to ensure they are in balance. You should have $ 129,030 in debits/credits.On your homepage in Quickbooks, you will see “Reports” on the left menu. Open the Reports page and print the reports and financial statements noted below to separate pdf files. RequiredNote: The date on the financial statements should be June 30, 2020. This represents 6 months, not a full year. • Journal• General Ledger• Trial Balance• Profit and Loss (Income Statement)• Balance Sheet• Statement of Cash FlowsSee your Financial Statement Project assignment in Blackboard. Complete the Financial Statement Project Questions page and submit along with the above reports and financial statements as pdf files ..

7 pages

In the 21st century, every business is supposed to conduct itself in a manner that is socially responsible, moral, and eth ...

In the 21st century, every business is supposed to conduct itself in a manner that is socially responsible, moral, and ethical. The age of digital ...

5 pages

Just Another Move To China

Reflecting on Lisa’s dual-career trailing spouse journey, how would you have approached An expatriate refers to a person ...

Just Another Move To China

Reflecting on Lisa’s dual-career trailing spouse journey, how would you have approached An expatriate refers to a person permanently or temporarily ...

Auburn University Climate Disasters in California Discussion

work 1Read the attached Case Study, Patagonia: A Sustainable Outlook on Business, then thoroughly answer the questions at ...

Auburn University Climate Disasters in California Discussion

work 1Read the attached Case Study, Patagonia: A Sustainable Outlook on Business, then thoroughly answer the questions at the end of the document. Please follow these basic guidelines as grades are based on how well the student complies with following these instructions:Responses must be organized and identify clear headings (i.e. Question #1, Question #2, question 3.)Each response is to demonstrate comprehension of the subject matterThe responses clearly relate to each question, and are to include supporting details and/or examplesProvide personal perspective and position, when necessaryAnswers should objectively reflect upon own analysis of the Company's corporate strategyIn addition, the Case Study Paper requires well constructed paragraphs, using proper grammar, sentence structure, punctuation, etc. (please use Grammarly on this assignment). Must be no less than one and a half (1 1/2) full double-spaced pages, but no more than three (3) pages long. Either 11-point or 12-point font size throughout is acceptable. Please cite all sources used for your paper (there are a number of sources identified at the end of the attached case study document for your consideration).This is where you will submit your Word Document for the Case Study Assignment.work 2Research an article (from a newspaper, magazine, internet site) of a current Sustainability (Environmental) story (the event must have occurred within the past six months). The story can be either positive or negative. Provide a recap of the article, identifying the critical points made by the author along with your main takeaways. Requirements for the paper include:Start your paper with a powerful opening sentenceAdd something unique from your perspectiveKeep the message simple; clarity is keyExplain what the article is aboutExplain why people should careProvide a powerful conclusionThe paper must also include a link to the article, or identify the source where the story appeared, the published date, the author, along with any other relevant information citing the source.Your "Sustainability News to Know" paper is to be no less than one full double-spaced page, but no more than two pages long. You are to use either 11 pt. or 12 pt. font and expected to use proper grammar, sentence structure, and punctuation (please use Grammarly for this assignment).work 3Read case study, "Succession Management at General Electric".Answer case questions 1-3.work 4Read case study, "Hiring FBI Agents" located on page 325Answer case questions 1-3 on page 325

Similar Documents

assignment help please

PLease no PLagiarism. Please read the instructions. Please write 200 words per bullet point and 2 slides for each bullet p...

Business Discussion Paper Continue Analysis of Problem Homework Help

We will continue to identify any general issues about the content of the course - specifically, the cases - that you are u...

Health & Safety assignment

Discuss Occupational Safety & Health Problems/ Challenge using scientific approach to resolve the issue. TASK:a.&...

5 pages double spaced

MGT321 SEUToy Manufacturing Standards Case study

College of Administrative and Financial Sciences Assignment 1 Deadline: 06/03/2021 @ 23:59 Course Name: Intro to Internat...

Orion's Move to Agile from Waterfall Project Management Paper & PPT

PLEASE GO THROUGH Proposal.docx before starting this. Overview of your project (Introduction in proposal.doc) • Content ...

Article Summary Worksheet

Article Title: What to Know about the Report on America’s COVID-Hit GDP 1. The COVID-19 pandemic has caused the most pro...

Finacial Analysiscc...

Analyze the impact of international trade on Huntington Ingalls financial statements Huntington operates on an internation...

Vice.edited.docx

Study help

Our tutors provide high quality explanations & answers.

Post question

PSC495 Grand Canyon University Problem Solutions Matrix Research Paper

Minimum 100 word response and if sources are used - cited. No format needed Question 1: In many projects, teams are ...

PSC495 Grand Canyon University Problem Solutions Matrix Research Paper

Minimum 100 word response and if sources are used - cited. No format needed Question 1: In many projects, teams are tempted to immediately identify solutions for implementation. Explain why is important to follow a process for understanding the problem, and who should be involved in final solution prioritization. Questions 2: On the "Problem Solutions Matrix," handout, the category "Customer Importance" received twice the weight of all other categories. Using what you learned from the Topic Materials, discuss the relative importance of this criterion. Discuss whether you think this weighting was appropriate, and explain why. Discuss whether there are additional criteria that should have had greater weight and explain why.

GCC A Rejection of Your Wedding Date Request Email & Discussion

Hello Class -To follow are instructions and a prompt for your SECOND GRADED WRITTEN ASSIGNMENT. It is based on chapter 7 a ...

GCC A Rejection of Your Wedding Date Request Email & Discussion

Hello Class -To follow are instructions and a prompt for your SECOND GRADED WRITTEN ASSIGNMENT. It is based on chapter 7 and entitled Radical Rewrite: Request Refusal—Nuptials Nixed at Napa Inn The below poorly written letter turns down the request of a bride-to-be seeking to reserve the popular Napa Valley Inn as a venue for her wedding.How can this letter be made less disappointing?Your Task. Analyze the message.List its weaknesses and what information is missing, thenOutline an appropriate writing plan. NEXT, use your analysis and REWRITE the letter, which you will submit via this assignment link. NOTE: You are NOT to answer the letter. Only rewrite to make it grammatically and stylistically correct. So, in a Word document you will outline the following:1) weaknesses you found in the document (in bullets)2) a brief strategy of how to rewrite the letter (two or three paragraphs)3) and the actual revised and final draft of your letter (your own version of the document)NOTE your letter should follow the exact same format that that is discussed in the textbook- i.e. Sender's and Receiver's full information, date, subject, salutation, intro., body, appropriate number of words per line and lines per paragraphs, etc.I strongly encourage you to refer to your textbook and as often as needed. Also, review my notes on your previously submitted and graded written assignments #1 ------look for detail on what I asked you to specifically improve on. Be as creative as you like both in your writing and the aesthetics of the letter. You will be replying as if you are the VP of Operations for the Napa Valley Inn. The use of fictitious (fake) dates and addresses is completely acceptable. Enjoy and make this learning experience count!++++++++++++BELOW IS THE MESSAGE/LETTER YOU NEED TO ANALYZE AND REWRITE ++++++++++Current dateMs. Sonya Capretta2459 Sierra AvenueFresno, CA 93710Dear Ms. Capretta:We regret to inform you that the wedding date you request in your letter of February 2 at the Napa Valley Inn is unavailable. Unfortunately, we are fully booked for all of the Saturdays in June, as you probably already suspected.June is our busiest month, and smart brides make their reservations many months—even years—in advance. That’s because the Napa Valley Inn is the ideal romantic getaway for weddings. With unparalleled cuisine and service, along with panoramic Napa Valley and vineyard views, our inn offers a unique, intimate ambiance in a breathtaking location for your special event.We apologize if we have caused you any inconvenience. However, if you could change your wedding date to the middle of the week, we would try to accommodate your party. We do have a few midweek spots open in June, but even those dates are rapidly filling up. With 45 Mediterranean-style rooms and suites, each with its own sunny private terrace, the Napa Valley Inn is the perfect location for you and your partner to begin your married lives. Afternoon ceremonies typically begin at 11 a.m., while golden sunsets at the Napa Valley Inn offer a romantic prelude of the evening to come. Evening ceremonies usually begin at 6 p.m. I’m available if you want to arrange something.Sincerely,[Your Name - title]

USF Financial Sheet Cash Flow Paper

check the file plzThe following events apply to your company’s first year of operations:January 1, 2020 - Acquired $20,0 ...

USF Financial Sheet Cash Flow Paper

check the file plzThe following events apply to your company’s first year of operations:January 1, 2020 - Acquired $20,000 cash from the issue of common stock.January 1, 2020 - Purchased $800 of supplies on account.January 1, 2020 – Purchased a truck for $10,000 cash. Salvage value is $2,000. Useful life is 4 years. January 15, 2020 - Paid $4,200 cash in advance for a one-year lease on office space starting February 1, 2020.March 31, 2020 - Earned $28,000 of revenue on account.March 31, 2020 - Incurred $12,500 of other operating expenses on account.March 31, 2020 - Collected $24,000 cash from accounts receivable.March 31, 2020 - Paid $9,000 cash on accounts payable.April 1, 2020 borrowed $10,000 from the bank on a 6 month Note Payable with a 10% interest rate. June 30, 2020 Paid a $3,000 cash dividend to the stockholders.The Stockholders would like to see how your company is performing in the first 6 months of operation and have asked for a complete set of Financial Statements for the period 01/01/2020 – 06/30/2020. Prepare the period end adjusting journal entries noted below, but keep in mind this is for 6 months of operation. Information for Adjusting Entries – all should be dated June 30, 2020.There was $150 of supplies on hand at the end of June 2020.The lease on the office space covered a one-year period beginning February 1, 2020.There was $3,600 of accrued salaries at the end of the period.Your company estimates uncollectable accounts receivable as 1% of sales on account. (You may have to choose a “customer” for your entry. Select “Complete Business Service” or another option that will allow you to post the journal entry.)Record Depreciation on the truck purchased on January 1, 2020.Record interest expense for the Note Payable dated April 1, 2020. Interest will be paid when the note is due.Once the events above are recorded, check the total debits/credits on your Journal to ensure they are in balance. You should have $ 129,030 in debits/credits.On your homepage in Quickbooks, you will see “Reports” on the left menu. Open the Reports page and print the reports and financial statements noted below to separate pdf files. RequiredNote: The date on the financial statements should be June 30, 2020. This represents 6 months, not a full year. • Journal• General Ledger• Trial Balance• Profit and Loss (Income Statement)• Balance Sheet• Statement of Cash FlowsSee your Financial Statement Project assignment in Blackboard. Complete the Financial Statement Project Questions page and submit along with the above reports and financial statements as pdf files ..

7 pages

In the 21st century, every business is supposed to conduct itself in a manner that is socially responsible, moral, and eth ...

In the 21st century, every business is supposed to conduct itself in a manner that is socially responsible, moral, and ethical. The age of digital ...

5 pages

Just Another Move To China

Reflecting on Lisa’s dual-career trailing spouse journey, how would you have approached An expatriate refers to a person ...

Just Another Move To China

Reflecting on Lisa’s dual-career trailing spouse journey, how would you have approached An expatriate refers to a person permanently or temporarily ...

Auburn University Climate Disasters in California Discussion

work 1Read the attached Case Study, Patagonia: A Sustainable Outlook on Business, then thoroughly answer the questions at ...

Auburn University Climate Disasters in California Discussion

work 1Read the attached Case Study, Patagonia: A Sustainable Outlook on Business, then thoroughly answer the questions at the end of the document. Please follow these basic guidelines as grades are based on how well the student complies with following these instructions:Responses must be organized and identify clear headings (i.e. Question #1, Question #2, question 3.)Each response is to demonstrate comprehension of the subject matterThe responses clearly relate to each question, and are to include supporting details and/or examplesProvide personal perspective and position, when necessaryAnswers should objectively reflect upon own analysis of the Company's corporate strategyIn addition, the Case Study Paper requires well constructed paragraphs, using proper grammar, sentence structure, punctuation, etc. (please use Grammarly on this assignment). Must be no less than one and a half (1 1/2) full double-spaced pages, but no more than three (3) pages long. Either 11-point or 12-point font size throughout is acceptable. Please cite all sources used for your paper (there are a number of sources identified at the end of the attached case study document for your consideration).This is where you will submit your Word Document for the Case Study Assignment.work 2Research an article (from a newspaper, magazine, internet site) of a current Sustainability (Environmental) story (the event must have occurred within the past six months). The story can be either positive or negative. Provide a recap of the article, identifying the critical points made by the author along with your main takeaways. Requirements for the paper include:Start your paper with a powerful opening sentenceAdd something unique from your perspectiveKeep the message simple; clarity is keyExplain what the article is aboutExplain why people should careProvide a powerful conclusionThe paper must also include a link to the article, or identify the source where the story appeared, the published date, the author, along with any other relevant information citing the source.Your "Sustainability News to Know" paper is to be no less than one full double-spaced page, but no more than two pages long. You are to use either 11 pt. or 12 pt. font and expected to use proper grammar, sentence structure, and punctuation (please use Grammarly for this assignment).work 3Read case study, "Succession Management at General Electric".Answer case questions 1-3.work 4Read case study, "Hiring FBI Agents" located on page 325Answer case questions 1-3 on page 325