Bright Academic Experts

Category: Accounting

  • build a DCF model

    I’ve attached a complete instruction document. It has everything you need, company backgrounds, financial assumptions and step-by-step guidance. You only ned to pick one of the 3 scenarios and ONE, build the DCF model in Excel and calculate NPV and IRR. Also, can you please complete these tasks.

    • Written Report ( 2,500 words max) containing:
      • Company & industry overview ( 250 words)
      • Separate, clearly labeled sections for Tasks 16
      • Summary of key findings & recommendations ( 300 words)
    • Excel file with:
      • DCF model (Task 1)
      • KPI and ratio calculations (Tasks 2 & 3)
    • PowerPoint Draft or Outline (Task 6) upload as .pptx outline.

    2. Interpret Manufacturing KPIs

    • Choose three KPIs common to manufacturers (e.g., gross margin %, inventory turnover, operating cash-flow ratio).
    • Calculate the last reported figure and one peer benchmark.
    • Explain what each KPI reveals about efficiency, profitability, or liquidity.

    3. Screen an M&A Target with Ratio Analysis

    • Identify one publicly traded U.S. manufacturing company that could be acquired.
    • Using its public filings, compute at least five core ratios (liquidity, leverage, profitability).
    • Conclude whether the target is financially sound and strategically complementary.

    4. Propose Strategic Alternatives

    • Based on public data and industry trends, outline two growth / sustainability strategies (e.g., reshoring, product diversification, green manufacturing).
    • Discuss qualitative fit and approximate financial impact (use rough order-of-magnitude estimates onlyno proprietary data).

    5. Analyze Stock Buyback Activity

    • Summarize buybacks disclosed in the last three fiscal years (shares repurchased, dollars spent, timing).
    • Discuss motives (EPS management, capital-structure optimization, signaling) and quantify effects on EPS and leverage.

    6. Communicate Results to Stakeholders

    • Prepare a concise, one-page financial brief that highlights:
      • Revenue and earnings trends
      • Cash-flow health
      • Balance-sheet strength/risk
    • Draft a PowerPoint outline (68 bullets and slide titles) that you would use to brief senior management or investors Emphasize clarity, plain language, and actionable insights.

    Requirements: As long as it needs to be to satisfy requirements

  • build a DCF model

    I’ve attached a complete instruction document. It has everything you need, company backgrounds, financial assumptions and step-by-step guidance.

    • Written Report ( 2,500 words max) containing:
      • Company & industry overview ( 250 words)
      • Separate, clearly labeled sections for Tasks 16
      • Summary of key findings & recommendations ( 300 words)
    • Excel file with:
      • DCF model (Task 1)
      • KPI and ratio calculations (Tasks 2 & 3)
    • PowerPoint Draft or Outline (Task 6) upload as .pptx outline.

    2. Interpret Manufacturing KPIs

    • Choose three KPIs common to manufacturers (e.g., gross margin %, inventory turnover, operating cash-flow ratio).
    • Calculate the last reported figure and one peer benchmark.
    • Explain what each KPI reveals about efficiency, profitability, or liquidity.

    3. Screen an M&A Target with Ratio Analysis

    • Identify one publicly traded U.S. manufacturing company that could be acquired.
    • Using its public filings, compute at least five core ratios (liquidity, leverage, profitability).
    • Conclude whether the target is financially sound and strategically complementary.

    4. Propose Strategic Alternatives

    • Based on public data and industry trends, outline two growth / sustainability strategies (e.g., reshoring, product diversification, green manufacturing).
    • Discuss qualitative fit and approximate financial impact (use rough order-of-magnitude estimates onlyno proprietary data).

    5. Analyze Stock Buyback Activity

    • Summarize buybacks disclosed in the last three fiscal years (shares repurchased, dollars spent, timing).
    • Discuss motives (EPS management, capital-structure optimization, signaling) and quantify effects on EPS and leverage.

    6. Communicate Results to Stakeholders

    • Prepare a concise, one-page financial brief that highlights:
      • Revenue and earnings trends
      • Cash-flow health
      • Balance-sheet strength/risk
    • Draft a PowerPoint outline (68 bullets or slide titles) that you would use to brief senior management or investors Emphasize clarity, plain language, and actionable insights.

    Requirements: As long as it needs to be to satisfy requirements

  • Accounting Question

    I need help on how to do this assignment, the professor created a excel template with formulas already set up, it requires me to log in my company’s balance sheets, income statements, statements of cash flows, and supplemental data, all information must zero out and i am having trouble doing that. i could send the dowloaded excel template on here and my companys 10-k from years 2020-2025. below is my excel spreadsheet that i have already done, i need it corrected if at all possible, the balance sheet for each year has to zero out.

    Requirements:

  • Head of Household Filing Status

    Scenario

    Janice Traylor is single and has an 18-year-old son, Marty, who has lived with her his entire life. This year, Marty joined the Marines and was sent on a special assignment to Australia for nine months. Although he was homesick, he knew the assignment was temporary.

    Janice has always filed as head of household, with Marty as her qualifying child. However, this year shes unsure whether she still qualifies due to Martys temporary absence. Shes come to you for guidance.

    Your Task

    • Research the requirements for head of household filing status and the qualifying child tests, including exceptions for temporary absences.
    • Write a professional response advising Janice on whether she qualifies for head of household this year. Be sure to explain your reasoning and reference the rules that apply.

    Submission Guidelines

    • Your response should be at least one page and written in your own words (no AI-generated content, no plagiarism).
    • Include properly cited sources and a Works Cited page.
    • Submit your completed assignment as a Microsoft Word document through the assignment link.

    Think of yourself as Janices trusted tax advisor. How can you clearly explain the rules so she understands her options and feels confident in her filing status?

  • Financial ratio analysis

    Use the company’s latest annual financial statements (Income Statement & Balance Sheet). Calculate and explain these ratios: Liquidity: Current Ratio, Quick Ratio Profitability: Gross Margin, Net Margin, ROA, ROE Activity/Efficiency: Inventory Turnover, Asset Turnover Debt: Debt-to-Equity, Interest Coverage Compare at least 2 years of data or compare to industry averages. Write a short paragraph explaining what each category shows about the company’s health. Identify strengths, weaknesses, and risks. End with 3-5 recommendations to improve performance. Keep it 2-4 pages, clear, and professional.

  • AC350 Accounting Information Systems

    *STEP 2 HAS ALREADY BEEN COMPLETED*

    StepS Instructions Points

    1

    Start Excel. Download and open the file named Excel_Ch03_SpaUsage.xlsx. Grader has automatically added your last name to the beginning of the file name. Save the file to a location where you are storing your files.

    		0
    2

    On the Monday Sales worksheet, in cell K2, enter a function to insert todays date.

    		8
    3

    In cell I2, enter a conditional math function to total the sales based on the criteria in cell H2. Use absolute referencing where necessary. Copy the function through cell range I2:I15.

    		10
    4

    In cell K5, enter a function to count the total number of services per day in column D.

    		 10
    5

    In cell I18, enter a conditional math function to total the sales based on the criteria of service and therapist. This function will need the use of both absolute and mixed references. Copy the function through cell range I18:K31.

    		 10
    6

    In cell L18, total the sales by service, and then copy the function through cell range L18:L31.

    		 0
    7

    In cell M18, enter a logical function to determine if the service is a popular service. If the Total Sales is greater than or equal to 200, then return a result of Yes, or else return a result of No. Copy the function through cell range M18:M31.

    		 0
    8

    On the ServicesPricing worksheet, create a named range SpaPrices for cell range A3:C16.

    		 2
    9

    On the ServicesPricing worksheet, in cell G3, enter an array formula to multiply the cost of each service by the service hours. Format cell range G3:J16 with the Comma cell style.

    		0
    10

    On the CustomerPricing worksheet, in cell B2, enter a VLOOKUP function to determine the prices for each service. Use the named range SpaPrices and look for an exact match.

    		0
    11

    As a service to spa members, the spa allows payment plans. On the PaymentPlan worksheet, in cell B6, calculate the monthly payment. Change the monthly payment in cell B6 to an absolute value.

    		 0
    12

    Save the workbook, exit Excel, and submit your file as directed.

    		 0

    Requirements: INSTRUCTIONS

  • Case 4-4 Threats to Audit Independence (pg. 296-297)

    Case 4-4 Threats to Audit Independence (pg. 296-297) To do First 2 Questions From Page 297

    Identify any potential threats to independence that exist based on the facts of the case?

    Thinking back to the biases discussed in Chapter 2, what biases might the identified threat(s) make Katy more susceptible to and why?

    Is Katy obligated to discuss her feelings about DGS with the compliance partner when they meet? If so, what should she say? Do you think the compliance partner should remove Katy from the audit? Explain.

    The SEC seems to be adopting the position that questions about the independence of auditors and the audit engagement can be made based on a materiality criterion. The reason given is that auditors may be able to maintain their objectivity and integrity even when certain relationships exist. In other words, Katys relationship with the CFO might be evaluated through the lens of how significant the relationship is with respect to an independent audit. What are the dangers of relying on materiality to judge independence and can reliance on objectivity and integrity be sufficient to make these judgments in Katys situation?

    Attached Files (PDF/DOCX): Pages 296-297.pdf

    Note: Content extraction from these files is restricted, please review them manually.

  • Accounting cycle and recording financial transactions

    CC 201 Milestone One Guidelines and Rubric Overview In previous modules, you examined the initial stages of the accounting cycle and practiced journalizing financial transactions. In Milestone One, you will complete the first part of your course project to demonstrate your ability to accurately record financial data, which will continue to be used to complete other parts of the project. Scenario You were recently hired as an entry-level bookkeeper for a service corporation that just opened this month. Your first task is to record business transactions for its first month using the source documents and transaction data the company will provide to you. This corporation hasnt set up its computerized accounting system yet, so you will apply the accounting cycle in Microsoft Excel to record transactions and generate financial reporting results for the organization. Directions Record Financial Data: Use generally accepted accounting principles to accurately capture business transactions for the month in the Company Accounting Workbook Template, which is linked in the What to Submit section below. Use the data provided in the Accounting Data Appendix document, which is also linked in the Supporting Materials section below. Specifically, you must address the following rubric criteria: Accuracy: Prepare entries that are accurate and fully reflect the appropriate information. Completeness: Prepare entries that are complete for each month, including transferring posted entries to T accounts. Unadjusted Trial Balance: Prepare the unadjusted trial balance portion of the Trial Balance tab of the Company Accounting Workbook, ensuring that the total debits and credits match. What to Submit Using the provided template, submit your Company Accounting Workbook Template with the following portions completed: the General Journal tab, the Ledger Accounts tab, and the Trial Balance tab. This assignment should be completed and submitted using the Microsoft Excel workbook template. Note that the first tab of the workbook provides you with the chart of accounts. These are the accounts you will use in recording transactions for the month

  • DataProj3

    THIS IS A TABLEAU PROJECT.

    Project Scenario: The Chief Risk Officer (CRO) of LendingClub is interested in exploring which loan grade has historically had the most charge offs (uncollected loans). She is requesting an analysis that includes the historic amounts of loans that were fully paid and charged off (not paid) only. She wants to be able to review the total dollar amounts paid and charged off for each loan grade. She asks you to perform the analysis using Tableau.

    Project Instructions:

    • Data preparation:
    • Open Tableau Desktop.
    • Connect to the dataset provided above.
    • Review the data types, and adjust them if necessary.
    • Click on the Sheet 1 tab.
    • Use the “Loan Amnt” field to sum the loan amounts
    • Use the “Loan Status” field to filter for “Charged Off” loans and fully paid loans
    • Use the “Grade” field to group the loans by grade
    • Verbal analysis:
    • Create a Word document and draft a hypothetical email to the CRO. Your email should include a recap of the work that you performed (use the AMPS model to help you), including the following:
    • A: Explain what question was being answered.
    • M: Describe any issues you had in using the data.
    • P: Give an overview of your analysis procedures.
    • S: Tell the CRO which grade had the most Charged Off loans by dollar amount. Also tell the CRO the total dollar amount of Charged Off and fully paid loans for the grade with the highest dollar amount of charged off loans.
    • Submit two files:
    • the Tableau Packaged Workbook. Note: in order to submit the Tableau Packaged Workbook, which is a format that you can share with me, you will need to save a copy for submission as a .twbx file NOT a .twb file.
    • the Word document.

  • Project Paper

    Assignment Instructions Cookie Business This project measures your mastery of ULOs 2.1, 3.5, and 3.6. Assignment Objective: In this project, you will be opening your own specialty cookie company to see how product costing methods and changes in production affect business decisions. You will be creating a series of reports and analyzing the results using the template provided to guide you through the project. You will: Gain an understanding of product costing (direct materials, direct labor, and overhead). Review job order costing. Review process costing. Make business decisions based on analyzing accounting data. Length: You will prepare a three- to four-page written report (including spreadsheets) using the Unit III Project Template. References: At least two peer-reviewed sources are required. Resources used are required to be scholarly/academic in nature . APA Style is required for citations and references. Details: First, start the paper with an introduction section per the assignment template provided above. Part 1: Establish a cookie business selling only one type of specialty cookie with two employees making the cookies. Create a name and establish a location for the business. Construct a mission statement for the business. Decide on the type of cookie you want to make and sell. Part 2: Develop costing and sales information for 1,000 cookies (this is the first and only order). Estimate and explain the cost per cookie based on job order costing (manufacturing overhead is 30% of direct labor costs). Prepare a job order cost sheet by researching and identifying the top five ingredients and their estimated costs as your direct materials. Research and identify the cost of wages for your two employees as your direct labor. It typically takes two days to make 1,000 cookies. For process costing, examine the costs per 1,000 cookies looking at these top three processes (departments): Mixing, Add-ins, Packaging. The Mixing Department will be examined in depth (only do this department). All materials will be added in at the beginning of the process. The cookies will be in the Mixing Department for a total of 8 hours (use two employees, 4 hours each as your direct labor). The cookies will be 100% complete with respect to materials, and only be 40% complete with respect to conversion costs (labor and overhead) before they are transferred to the Add-ins Department. Manufacturing overhead is 30% of direct labor costs. Estimate and explain the sales price you plan to set per cookie based on the cost data. Part 3: Define job order and process costing. Then, compare and contrast the costing methods used in this project (job order vs. process costing), including which you believe provides the most useful information as a manager. Part 4: Discuss what will happen to revenue if the number of the cookies sold increases or decreases. End this paper with the key observations and present any future recommendations. Use the Unit III Cookie Project Spreadsheet Templates for your job order, and process costing spreadsheets to be embedded in your case study document.

    Attached Files (PDF/DOCX): UnitIII_Project_Template(1).docx

    Note: Content extraction from these files is restricted, please review them manually.