{"id":47242,"date":"2022-03-31T04:08:49","date_gmt":"2022-03-31T04:08:49","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/quantitative-analysis-word-and-excel\/"},"modified":"2022-03-31T04:08:49","modified_gmt":"2022-03-31T04:08:49","slug":"quantitative-analysis-word-and-excel","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/quantitative-analysis-word-and-excel\/","title":{"rendered":"Quantitative analysis word and excel"},"content":{"rendered":"<div>\n<p>\u00a0<\/p>\n<h2>Instructions<\/h2>\n<p>All information required for this assignment is provided below:<\/p>\n<p>Read the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/herzing.instructure.com\/courses\/9697\/files\/1545162\/download?wrap=1\" title=\"Unit 4_Cash Is King.pdf\"><u>Cash Is King<\/u><\/a><u> <\/u>case study and complete the following requirements.<\/p>\n<p><strong>Quantitative Analysis:\u00a0<\/strong><\/p>\n<ol>\n<li>Using the data input provided (Exhibit 1), prepare LAF\u2019s master budgets in Excel. Do not hard-code numbers into the spreadsheet, except where permitted in the financing section of the cash budget.<\/li>\n<\/ol>\n<p><strong>Qualitative Analysis:\u00a0<\/strong><\/p>\n<p>In a 2 page report, based on the results of your quantitative analysis:<\/p>\n<ol>\n<li>Determine a credit recommendation for Kent Bank, to lend or not. Justify your credit decision.<\/li>\n<li>Explain why the cash budget is more important to a bank than the accounting net income when determining a credit decision.<\/li>\n<\/ol>\n<h3>Deliverables<\/h3>\n<ul>\n<li>Quantitative Analysis (Excel Required): You are required to use the provided Excel workbook to complete the quantitative analysis for this assignment.<\/li>\n<li>Qualitative Analysis (Word Required): Prepare a 2-page summary addressing the required qualitative analysis, as noted in the Student Workbook.\u00a0 Your paper is required to be formatted according to APA requirements.\u00a0 Be sure to incorporate key concepts from this unit&#8217;s readings and properly cite your references according to APA requirements.\u00a0 Do NOT embed the results of your quantitative analysis in your Word document.\u00a0 You should only reference parts of your quantitative analysis in your written analysis.\u00a0 Your written responses to the qualitative prompts should not be presented in a question and answer format.<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Instructions All information required for this assignment is provided below: Read the Cash Is King case study and complete the following requirements. Quantitative Analysis:\u00a0 Using the data input provided (Exhibit 1), prepare LAF\u2019s master budgets in Excel. Do not hard-code numbers into the spreadsheet, except where permitted in the financing section of the cash [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-47242","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=47242"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/47242\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=47242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=47242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=47242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}