Category: Excel

  • “Streamlining Inventory Management through Data Analysis and Automation: A Case Study in Retail”

    For
    this project, think of a situation in business/organization or in your personal
    life where you can apply the analysis and tools we learned throughout the
    semester to improve or automate decision-making. You can use
    functions, pivot table, macros, as well as things beyond what you leaned in the
    class.
    The
    goal is that application of these tools can help the business/organization to
    run more efficiently or effectively. There are two general directions you can
    take to achieve this goal:
    ·     
    extract insights from data to help firm improve their operations
    or make better decisions,
    ·     
    automate certain operations so that it is easier for users/decision-makers
    to search and access information or insights.
    You
    can pick one of them or do a hybrid of both.
    Submission
    Your
    final submission should include an Excel file with your data and
    analysis and a recorded presentation with slides that explain: 1. The
    scenario 2. How your analysis/automation help with the business/organization. 
    I
    am grading your project mainly based on two aspects.
    ·     
    The technical aspect: whether the tools you use is appropriate
    for the analysis and the sophistication level of the tools
    ·     
    The business aspect: whether you are solving a meaningful
    problem (to aswer the “so what” question)

  • Excel Charts and Visual Aids Practice Files

    In these two assignments, there is strict rules to SHOW WORK. Showing work is how this assignement is completed, please attatch the answers into the right slot, the questions are to left side of the assignment. If you have any questions you can reach out to me. Plase do all of thw work on excel and turn in the answers with an excel link. 
    Directions: Charts and other visual aids are important features of Microsoft Excel and other data analytic platforms. Visualization tools allow you to effectively communicate data insights to others. The following video covers some basics of creating and modifying charts in Excel. Please review the video before working through the practice files below (2 practice files in this lesson), and before taking the quiz (below this assignment on the Modules page).

    Please upload your practice files after completing the exercises. If you save files to your computer, you can upload more than one file at a time. If you are submitting from OneDrive, you might have to submit twice, i.e. it seems like resubmitting, but with a different file – we’ll see both!
    The two practice files that need to be completed are attatched below

  • “Plagiarism-Free Solution to Assignment Prompt: Solving Paragraphs with Accuracy”

    Please do a correct solution without mistakes, without similarities, without plagiarism. Put the answer in the file and make sure to solve all the paragraphs. If you do a good job, I have many assignments that I will ask you to do. Check yourself and do your best
    Make sure the plagiarism rate is zero

  • Commission Calculation Worksheet for Lease of 1700 Pennsylvania Avenue, Washington DC Commission Calculation Worksheet for Lease of 1700 Pennsylvania Avenue, Washington DC Property: 1700 Pennsylvania Avenue, Washington DC Tenant: ABC Company, a technology relocating

    Please provide a commission calculation worksheet for the following transaction. The worksheet should include both the annual amount of commissions paid and the total commission the landlord will pay all brokers. The terms of the lease are as follows:
    Property – 1700 Pennsylvania Avenue, Washington DC
    Tenant – ABC Company, a technology relocating from 1400 K Street, NW
    Landlord – BIG Real Estate Company, a National REIT which recently purchased the building
    Lease Type – Full Service Lease (including a base year for operating expenses and real estate taxes)
    Area – 25,000 sq. ft on the 3rd floor of the Property.
    Lease Commencement Date – July 1st, 2024
    Rent Commencement Date – January 1, 2025
    Lease Term – 15 Years from the Lease Commencement Date
    Base Rent – $50.00 per sq. ft.
    Annual Base Rent Escalation – 2.5% per year
    Rent Increase – $3.00 rent increase in years 6 and 11 in lieu of the Annual Base Rent Escalation
    Rental Abatement – 6 months of free rent in both year 1 and year 2
    Tenant Broker’s Commission Rate – 3%
    Landlord Broker’s Commission Rate – 2%
    Payment Terms – The 1st half of the commission will be paid upon lease signing and the 2nd half will be paid upon the Lease Commencement Date.

  • “Forecasting Blood Donations in a University Using 3-Year Moving Average”

    Helping others through blood donation is a form of social solidarity or social responsibility. The blood donors cite a sense of social responsibility as their reason for donating blood, and as a result, the communities value and reward this activity. The following table shows the number of blood donors in a university from 2011–2023. Develop a 3-year moving average forecast and obtain the related statistical measures using excel QM.

  • Commission Calculation Worksheet for ABC Company Lease at 1700 Pennsylvania Avenue, Washington DC Commission Calculation Worksheet for ABC Company Lease at 1700 Pennsylvania Avenue, Washington DC Lease Details: Property: 1700 Pennsylvania Avenue, Washington DC Tenant

    Please provide a commission calculation worksheet for the following transaction. The worksheet should include both the annual amount of commissions paid and the total commission the landlord will pay all brokers. The terms of the lease are as follows:
    Property – 1700 Pennsylvania Avenue, Washington DC
    Tenant – ABC Company, a technology relocating from 1400 K Street, NW
    Landlord – BIG Real Estate Company, a National REIT which recently purchased the building
    Lease Type – Full Service Lease (including a base year for operating expenses and real estate taxes)
    Area – 25,000 sq. ft on the 3rd floor of the Property.
    Lease Commencement Date – July 1st, 2024
    Rent Commencement Date – January 1, 2025
    Lease Term – 15 Years from the Lease Commencement Date
    Base Rent – $50.00 per sq. ft.
    Annual Base Rent Escalation – 2.5% per year
    Rent Increase – $3.00 rent increase in years 6 and 11 in lieu of the Annual Base Rent Escalation
    Rental Abatement – 6 months of free rent in both year 1 and year 2
    Tenant Broker’s Commission Rate – 3%
    Landlord Broker’s Commission Rate – 2%
    Payment Terms – The 1st half of the commission will be paid upon lease signing and the 2nd half will be paid upon the Lease Commencement Date.

  • Title: Regulatory Analysis of NBT Bancorp: Part II – Soundness and Liquidity

    Your analysis of the case study bank will take a giant leap forward with Part II. This part will
    concentrate on regulatory attributes of soundness and liquidity for your assigned bank.
    Banks don’t necessarily provide all info required for an outsider to run these calculations. Some
    assumptions must be made. For example, a 30-day cash out flow can be assumed to be some credit
    line funding, 1/12 of the total of CDs maturing this FY, and a proportion (5-10% runoff) of
    deposits. (To get the amount of credit line fundings, check the bank’s OBS liabilities. For CD
    totals, check notes for Deposits.)
    Purpose:
    Develop an understanding of the criteria of banking regulations, and the areas of particular interest
    to regulators.
    Instructions:
    Use the bank data you compiled when you were doing Part I. Use the amended cover sheet
    provided in this week’s files. Copy and paste the format to your existing cover sheet. After
    completion of the calculations, determine if you believe the bank is in compliance. (They probably
    are). Upon completion, upload your file to canvas. 50 points total.
    Calculations Required (see PowerPoint “Global Banking Regulations and Standards”):
    Capital Adequacy Ratio (CAR) Liquidity Coverage Ratio Net Stable Funding Ratio Attached is calculations from Part 1 for assigned bank which is NBT bancorp. Also add cover page to excel that looks like the following attached form

  • “Analysis of Regulatory Attributes of Soundness and Liquidity for NBT Bancorp”

    Your analysis of the case study bank will take a giant leap forward with Part II. This part will
    concentrate on regulatory attributes of soundness and liquidity for your assigned bank.
    Banks don’t necessarily provide all info required for an outsider to run these calculations. Some
    assumptions must be made. For example, a 30-day cash out flow can be assumed to be some credit
    line funding, 1/12 of the total of CDs maturing this FY, and a proportion (5-10% runoff) of
    deposits. (To get the amount of credit line fundings, check the bank’s OBS liabilities. For CD
    totals, check notes for Deposits.)
    Purpose:
    Develop an understanding of the criteria of banking regulations, and the areas of particular interest
    to regulators.
    Instructions:
    Use the bank data you compiled when you were doing Part I. Use the amended cover sheet
    provided in this week’s files. Copy and paste the format to your existing cover sheet. After
    completion of the calculations, determine if you believe the bank is in compliance. (They probably
    are). Upon completion, upload your file to canvas. 50 points total.
    Calculations Required (see PowerPoint “Global Banking Regulations and Standards”):
    Capital Adequacy Ratio (CAR)
    Liquidity Coverage Ratio
    Net Stable Funding Ratio
    Attached is calculations from Part 1 for assigned bank which is NBT bancorp.
    Also add cover page to excel that looks like the following attached form

  • “Fixing Formulas and Creating Accurate Financial Reports in Excel”

    Hi. I already have the excel done I just need help fixing the formulas. The balance sheet on the right in the excel the not highlighted one needs to have the exact numbers as the pictures I have below. EXACTLY the same. With formulas do not just copy paste. ASK IF YOU HAVE QUESTIONS. And also fix the chart

  • “Fixing Formulas and Charts in Excel Balance Sheet”

    Hi. I already have the excel done I just need help fixing the formulas. The balance sheet on the right in the excel the not highlighted one needs to have the exact numbers as the pictures I have below. EXACTLY the same. With formulas do not just copy paste. ASK IF YOU HAVE QUESTIONS. And also fix the chart. Please ask if you have questions and please have it on time the deadline is soon. I CAN NOT ADD MORE TIME!!