Bright Academic Experts

Category: Excel

  • Final Project

    the instructions are mentioned on the file, pls do not use AI

  • EXCELSTAT 7

    All details are attached in the screenshots. If you have any questions feel free to ask.

  • HELLO I WANT YOU TO BUILD FOR ME TWO MUITIPLE FOR VALUATION…

    Hello i send for you report guidlines i want an excel sheet + word also i want you to build DCF model because i need it learning by myself.
    my instructor guidlines

    The goal of this report is to apply investment analysis concepts to a real-world company (publicly listed). Each student will develop a brief equity research report that includes qualitative and quantitative analysis, leading to a recommendation on whether to buy, hold, or sell the stock.

    • The report should be 2 to 5 pages with a structure similar to the reports in the provided link. Scroll down and go to Company Report
    • 10 numeric indicators which you personally will look at carefully when analyzing and valuing a company.
    • The student is expected to use one or two multiples in the valuation. (DCF is not required)
    • Each student needs to choose a company using the provided link, which must be different from the group project companies I shared earlier.
    • Each student needs to submit the Word file report and the Excel file.
    • The deadline is May 5, 2026.

    The company:Saudi Basic Industries Corp

    this is the comany and here you can find the finanical reports

  • must complete the problems using.@Risk,

    you must do this for two students.

  • You must have Risk@ also I need this for two students. So tw…

    you must access Risk@

    two copies

    two students

  • You must complete the problems using.@Risk,.

    I need it now today also I need to copies for two students of the same homework. So I need one for me and my friend

  • Dashboard for work tasks

    I need a professional dashboard in Arabic for business task and I will share the Excel that I want the dashboard in

  • S!_A10: Music Royalty

    You are designing a database to keep track of royalty distribution for songs released by different music labels. Some entities are marked in red. You may need to create additional entities to complete the design.

    Each Song is identified by a unique SongID. The Song entity should store Song Title, Genre, Language, and Release Date.

    The system keeps a list of all Contributors involved in songs. A contributor may be a singer, songwriter, or musician. Each Contributor is identified by a unique ContributorID. The Contributor entity should store Contributor Name, Stage Name (if any), and Contributor Type (such as Singer or Musician).

    Each contributor may be contracted with a Music Label (such as Warner Music, Disney, etc) for a specific period of time. You need to store Label Name, Headquarters City, Primary Contact Name and Primary Contact Email. Create or assign a suitable Primary Key.
    Note that a Label has contracts with many contributors, each for specific period of time. For each contract, store Contract Start Date and Contract End Date.

    A song may involve multiple contributors, and a contributor may work on multiple songs. For each contributors participation in a song, the system needs to store:

    • Role in the Song (such as Lead Singer, Backing Vocalist, Drummer, Lead Guitarist etc)
    • Royalty Percentage

    Design a database for this problem. If needed, create additional entities so that the relationships are correctly captured. Make sure to identify a Primary Key for each entity. If a natural Primary Key is not available for an entity, create a surrogate Primary Key. Also identify Foreign Keys as needed.

    Create an ERD in Draw.io. Show all entities with attributes, clearly identify Foreign Keys, and include correct relationship lines.

    Note:

    • The relationship lines MUST show ONLY the cardinality symbol ( | or crow’s foot) on each end. You may need to modify the default relationship lines in Draw.io.
    • Make sure the lines connect Primary Keys of a table with corresponding foreign keys of the child table.

    Bonus:
    A song earns royalties over time through different channels. Add any necessary entities to the ERD to store the monthly royalty amount earned by each song from channels such as streaming, radio, and track downloads.

    Submission: .drawio file, PDF, or screenshot. If you are submitting a PDF or an image, make sure that the entire diagram is clearly visible, otherwise you will receive no credit.

    Grading:
    DB Design:

    • Entity & Attribute Completeness (10 pts): all required entities and all their corresponding attributes are present in the ERD. Correct entity shape is used (as discussed in class).
    • Keys (5 pts): Primary Keys and Foreign Keys are clearly marked.
    • Relationships (5 pts): Relationships correctly model one-to-many and many-to-many relationships.

    Draw.io Diagram

    • Relationship Lines / Connection (2 pts): Lines must connect the Primary Key of the parent table to the Foreign Key of the child table. Relationship lines must be attached to entities, so that moving entities will adjust the lines.
    • Cardinality Symbols (2 pts): Correct use of cardinality symbols (I or crow’s foot only) on both ends of all relationship lines.
    • Clarity (1 pt): Diagram is neat, readable, with minimum criss-crossing of lines.

    Bonus: 5 pts

  • Excel Question

    Rules: You are expected and required to do your own work on these assignments. You may not work together with anyone on the same computer. You may not share computer files. You may, however, work together with someone if you are using separate computers and doing your own work. You may ask anyone for help as long as you do your own work. The capital budgeting process is very important, and calculation of NPV and IRR are central to the accept/reject decision. NPV profiles provide a graphical view, and what-if analysis can show the effects of changes in key variables. Suppose your company must regularly choose between a pair of mutually exclusive projects. Given the cash flows for the project, perform the tasks described below in THREE separate worksheets. For the project cash flow data, use the data file provided under the assignment. Excel Assignment 4 Cash flows 2026 Spring.xlsx 1. In a worksheet named Your_last_name_NPV, (Moon_NPV for example): Name the discount rate using your last name, for example, Moon_CoC and use the name in your formula. Compute the NPV, IRR, and MIRR using the corresponding Excel functions and make appropriate interpretations of the computed numbers in your own words (not definitions). Your interpretations of the results must be by completing the following sentences For NPVs, Project A’s NPV suggests that the total value of the company would increase/decrease by $$$, while project B ; if they are independent, the company should choose ___; if mutually exclusive _____ For IRRs (MIRRs), the annual rate of return on the project A is expected to be ____ over xx years, while ; if they are independent, the company should choose ___; if mutually exclusive _____ Find the cross-over rate and make an interpretation of the result. It also should show what the NPV value is at the cross-over rate. Develop NPV profiles based on your input data. Have the discount rates range from 0% to 28% by a 2% increment. Put both projects A and B on the same chart and include labels appropriately. 2. In a worksheet named Your_last_name_Modified CF: Compute and interpret the payback period for each project. Compute MIRR for each project by creating relevant columns to transform the original cash flows to modified cash flows. Although I demonstrate how to compute Discounted Payback on the video, that is not part of the requirements for this project. 3. In a worksheet named Your_last_name_Unequal lives: Conduct an appropriate analysis for the unequal life projects that are mutually exclusive (hint: EAA), and explain your results. Be sure to make the decision using a =if() statement. Also Comment what the EAA amounts mean. ***There should be THREE separate worksheets named accordingly. Grading Rubric Points NPV IRR MIRR calculations 6 Interpretations 4 Paybacks and interpretations 4 What if (data table); Chart 5 Crossover rate and interpretation 2 MIRR- modified cash flows 5 EAA and interpretation 4 Total 30 *Discounted payback is NOT part of this assignmen

  • HW XLSTAT 6

    All details provided below. Need to you only XLSTAT to complete this question.