Category: Finance

  • “Apple’s Inventory Management: A Spreadsheet Solution”

    For this discussion you will design a spreadsheet model to solve a problem currently faced by Apple. Describe the problem and design a spreadsheet model to solve it. You will create a sketch of the model, or create an outline in Excel. You can keep it very simple, but be sure to capture the essence of the problem and solution.

  • “Renovations Worksheet Formulas and Functions”

    On the Renovations worksheet in cell G6, enter a formula using an absolute reference to determine the new capacity that the Musica Room will hold based on the capacity in cell F6 and the percentage in cell B13. Copy this formula to the range G7:G10.
    Assign the named range IncreaseInRevenue to cell B14. Ensure that a single cell is selected when naming the range. Be sure to enter the range name exactly as specified with no spaces or extra characters.
    In cell I6, enter a formula to determine the projected revenue for the Musica Room based on the revenue figure in cell H6 and the percentage in cell B14. Use the named range in cell B14 when entering this formula. Copy this formula to the range I7:I10.
    In cell D6, enter the DATEDIF date function to determine the length in days of the expected renovation for the Musica Room. Copy this function to the range D7:D10.
    In cell B15, enter the function to calculate the median length of renovations in days. Assign the named range MedianDays to the cell.
    In cell J6, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in cell B15; otherwise, have the word Over display. Use the named range for B15 when entering this function. Copy this function to the range J7:J10.
    In cell B21, enter a function that will calculate the monthly payment for the loan amount in cell B18, based on the Annualized Rate in B19, and the number of years in the Term in cell B20. Use cell references B18, B19, and B20 in the function. Display the monthly payment as a positive value by entering a minus sign in the correct position in the function.
    Assign the named range RoomClassification to A24:B27.
    In cell K6, using a VLOOKUP, create a function to determine the projected room classification based on the projected quarterly revenue after renovations in cell I6. Use the named range RoomClassification when entering this function. Copy this function to the range K7:K10.
    Enter the File Name field in the left footer of the Renovations sheet.
    Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

  • Title: Balanced Scorecard Analysis of Company XYZ

    Many companies use a balanced scorecard system to track and manage their performance. According to Garrison, Noreen, and Brewer (2021), a balanced scorecard “consists of an integrated set of performance measures that are derived from and support a company’s strategy.” In a Balanced Scorecard (BSC), the company’s strategy is translated into a system of performance measures that are used to monitor the company’s performance in meeting its strategic objectives.
    Your task for this assignment will be to identify and discuss key performance measures used in an actual balanced scorecard example of any ONE real organization. Select the company of your choice; however, please make sure that you will be able to access their BSC information.
    This can be readily accomplished by doing a search of the library databases, Google Scholar, or other source available to you along with our textbook readings. To further assist in your understanding of this topic, in addition to finding information relating to a balanced scorecard example you might also want to do supporting searches on dashboards and also Key Performance Indicators (KPIs), as these are two contemporary terms related to the balanced scorecard concept.
    Discuss in as much detail as possible the specifics of each of the elements in the balanced scorecard that is being used your selected company. You will also need to analyze the significant strengths and weaknesses of the organization’s balanced scorecard.
    Deliverables
    You should prepare a 7-9 slide PowerPoint presentation (not including the cover page slide and references slides), explaining the specifics of the balanced scorecard utilized by the company you selected in your research. In your presentation, be sure to address each of the four performance measures:
    1. Financial 2. Customer
    3. Internal Business Process
    4. Learning and Growth
    For each of these performance measures, identify and discuss the most significant Key Performance Indicators that appear in the performance measure. Also, your presentation should include your analysis of the strengths and weaknesses of your company’s balanced scorecard. You should include at least two strengths and two weaknesses in your analysis. Your PowerPoint presentation should also include voice narration for each of the content slides. The length of the narration should be approximately 8-10 minutes for the entire presentation. APA standards are required to be followed for this presentation.
    For the audio just write the narrative out and I will read the audio out.

  • Title: Taiwan’s Balance of Payments Situation in 2019: A Comprehensive Analysis Introduction Taiwan, officially known as the Republic of China, is a small island nation located in East Asia. It is a highly developed and export-oriented economy

    country: Taiwan
    Discuss your country’s balance of payment (BOP) situation from 2019 with some observations.
    Requirements
    1. Analyze:
    – Trade Account
    _ Current Account
    – Capital Account
    2. Do you find any significant differences in the trade and current account balances during this time?
    3. How far of these differences might have happened due to Covid-19 and the Ukriane War?
    References should be used.
    AI-related software should not be used to write the assignment.
    – Word Limit: Minimum 1,000 words.
    refercences: APA

  • “Step 4: F/S Analysis Worksheet for Group Project”

    I am in a group project meaning that in the “Special Project Template As of January 08, 2024” I am required to only do Step 4 , so in the Excel Template “F/S Analysis Worksheet” has to get done.

  • Title: Results and Discussion: Application of Ohlson’s Logit Model on Financial Distress Prediction

    I have attached the assignment brief and the results from STATA. Please write the Results & Discussion section for this. I follow Ohlson (1980) and use logit for both univariate and multivariate. My study surround Ohlson’s logit model which developed from univariate and multivariate.

  • “Assessing Management’s Value Creation: A Financial Analysis of Apple’s Financing, Investing, and Operating Decisions”

    This assignment is an extension to the one you did in the financial statement analysis course. In the accounting assignment, we analysed the accounting choices management made while recognising revenues and expenses over the study period. In this assignment, we are examining the same companies to assess their financing, investing, and operating decisions. You are required to estimate the cost of financing (WACC), rate of return on equity & rate of return on invested capital and decide whether management have added value to the shareholders over the study period or not. If you have questions, please let me know.
    Preferred Apple, if you prefer an other company please let me know.
    Kindly see the attached files instructions and guidlines and Analytical Assignment / Homework Rubric (how the file will be graded by the instructor)

  • “Consolidating Previous Papers: Organizing Sections 1-5”

    everything has been uploaded.
    previous papers just need to be put together organized from sections 1 – 5

  • “Improving Financial Processes at Mex Ready Mix Concrete Company: An Internship Report”

    2. no matching ratio
    3. Apa reference style
    4. I have attached report and 2 for the things i have done during my internship
    5. i want someone who adjust the final report to be about finance department in (Mex Ready Mix concrete company)