Joshua Emmanuel
Joshua Emmanuel
  • 227
  • 27 434 070
NPV & IRR: Formula + TI BA II Plus + Excel – Equipment Purchase & Residual value
Calculating the NPV and IRR: A piece of equipment purchased today for $20,000 can generate the following cash flows over 4 years:
Year 1: $5,500
Year 2: $7,000
Year 3: $8,000
Year 4: $4,500
At the end of Year 4, the equipment can be sold for $3,500. Assume an 8% required rate of return.
Переглядів: 30

Відео

Financial Planning + Inflation- College Education investment: Real Rate - (BA II Plus & Excel)
Переглядів 32614 днів тому
This video shows how to calculate exactly how much to save TODAY to cover a child’s future education using nominal inflation rate. A couple wants to determine the sum of money needed today to fund their child’s education. • The child is currently six years old. • The child will start college at 18 and attend for 4 years. • The current cost of college is $25,000 per year. • The inflation rate is...
Select items from Vectors in R: Indexing and Subsetting in R Studio | A Beginner's Guide
Переглядів 278Місяць тому
This video shows how to create vectors, access and subset their elements, and use logical conditions to select specific values. Vectors are a fundamental building block in R, and mastering them will make your data analysis tasks much easier. 00:00 - Intro 00:26 - Selecting elements from a vector in R 01:36 - Excluding items from a vector in R 02:14 - Logical Subsetting in R 02:36 - Combining lo...
T-Tests in R Studio: One Sample Mean with raw data | One-Tailed & Two-Tailed
Переглядів 362Місяць тому
How to perform t.test for one-sample mean in R! We'll use the built-in "cars" dataset to explore: • Hypothesis testing: Learn how to test if the average speed in the dataset differs from a specific value. • Confidence intervals: Discover how to interpret confidence intervals and draw conclusions about the true mean. • Two-tailed vs. one-tailed tests: Understand the difference and when to use ea...
Hypothesis Z-Tests in RStudio: A Step-by-Step Guide (One Sample Mean)-1 & 2 tailed tests
Переглядів 428Місяць тому
This video dives deep into performing Z-tests for one-sample mean in R, exploring different significance levels and critical value approaches for a comprehensive understanding. • Two-tailed vs. one-tailed tests: Understand the difference and when to use each approach. • Calculating test statistics and p-values: Learn the formulas and interpret the results. • Significance levels and critical val...
Confidence Intervals for one Population Mean in R (Z & t) - Summary & Raw Data
Переглядів 370Місяць тому
This video walks you through constructing both Z and T confidence intervals for a population mean: known and unknown population standard deviations & raw data. You'll learn: • How to calculate the standard error of the mean • The difference between Z and T distributions • Using R functions like qnorm and qt to find critical values • Building confidence intervals with code examples • Utilizing R...
Population Standard Deviation in R - Sum of Squares, Variance, SD in RStudio
Переглядів 4742 місяці тому
Discover how to calculate both sample and population standard deviation and variance in R. This video demonstrates step-by-step how to compute these statistics using built-in functions and manual calculations. Learn the difference between sample and population metrics and how to find these values for your dataset. Confidence Intervals for one Population Mean in R (Z & t) - Summary & Raw Data: u...
Draw Normal Curves in RStudio with shading -Calculate Probabilities & Critical Z Values
Переглядів 3862 місяці тому
How to draw normal curves, calculate probabilities and values in R using the mosaic package. Functions used includes xpnorm, xcnorm, and xcnorm. 00:00 - Intro 00:13 - Installing the mosaic package for R 00:40 - Calculating areas under the curve with specified mean and standard deviation 01:47 - Customizing x-axis boundaries for precise visualization 02:12 - Drawing shaded areas between two Z sc...
Areas under Normal Curve in R | Calculating probabilities in R Studio
Переглядів 6002 місяці тому
How to calculate areas under the normal curve is statistical software R. Confidence Intervals for one Population Mean in R (Z & t) - Summary & Raw Data: ua-cam.com/video/36blwDtwNGs/v-deo.html
Mean, Standard Deviation, Variance on BA II Plus Calculator | Probability Distribution x̄, SD, σ²
Переглядів 2,1 тис.4 місяці тому
This video shows how to compute the population mean, standard deviation and variance on the BAII Plus calculator. 00:00 Intro 00:11 Entering Data Values 01:13 Generating Statistics (mean, sd, variance)
Discounted Cash Flows on BAII Plus - NPV, IRR, PB, DPB, PI - DCF - Capital Budgeting
Переглядів 8494 місяці тому
This video shows how to solve capital budgeting DCF problems using the BA II Plus calculator. Step-by-step instructions are provided to calculate Net Present Value (NPV), Payback Period, Discounted Payback Period, Internal Rate of Return (IRR), and Profitability Index (PI). Through clear explanations and practical demonstrations, learn essential techniques for evaluating the viability of invest...
General Annuity Problems Solved in Excel or Google Sheets - FV & PV: Ordinary (END) & Due (BGN)
Переглядів 5244 місяці тому
This video shows how to solve general annuity problems in Excel (or Google Sheets): Future Value and Present Value problems. It also shows how to calculate periodic rate for general Simple Annuity in Excel: ua-cam.com/video/ve7y6lJATgM/v-deo.html 00:00 Introduction to General Annuities 00:20 Future Value Problem 00:45 Periodic Rate for General Annuity 01:37 Calculating Future Value 02:24 Future...
Moving Averages in Excel -MAD (MAE), MSE, MAPE | Forecast + Graph
Переглядів 9 тис.4 місяці тому
This video shows how to quickly calculate moving averages & weighted moving averages in Excel. 00:00 4-period moving averages 00:27 Calculating forecast errors 02:29 3-period moving averages 03:54 2-period weighted moving averages 05:29 Moving Average chart
Draw Bell-Shaped Curves in Microsoft Excel and PowerPoint | Normal Distribution | Shade area
Переглядів 1,5 тис.4 місяці тому
This video shows how to draw standard normal curve in Microsoft Excel PowerPoint, including how to shade tail area and middle portion. 00:00 Generating curve in Excel 01:05 Pasting Special into PowerPoint as Group 01:22 Ungrouping object in PowerPoint 01:52 Shading regions under the curve
Annuity Calculations in Excel - FV, PV, PMT, N | Simple - Ordinary (END) & Due (BGN)
Переглядів 7315 місяців тому
Annuity Calculations in Excel - FV, PV, PMT, N | Simple - Ordinary (END) & Due (BGN)
Solved: Compound Interest Problems in Excel-Future, Present Values, Rate, Periods Examples +Template
Переглядів 5095 місяців тому
Solved: Compound Interest Problems in Excel-Future, Present Values, Rate, Periods Examples Template
Solved Examples: Normal Approximation to Binomial Distribution -Probability | Continuity Correction
Переглядів 2 тис.5 місяців тому
Solved Examples: Normal Approximation to Binomial Distribution -Probability | Continuity Correction
Create Payoff Table | Excel | Cost, Selling Price, Profit, Shortage, Excess, Demand/Supply
Переглядів 1,7 тис.5 місяців тому
Create Payoff Table | Excel | Cost, Selling Price, Profit, Shortage, Excess, Demand/Supply
Solved -Probabilities: AND, OR, GIVEN | Joint, Conditional, Union + Complements
Переглядів 6676 місяців тому
Solved -Probabilities: AND, OR, GIVEN | Joint, Conditional, Union Complements
Hypothesis Test for Proportion Template in Excel/Google Sheets | Critical & P-values
Переглядів 2 тис.6 місяців тому
Hypothesis Test for Proportion Template in Excel/Google Sheets | Critical & P-values
Hypothesis t-test Template for mean in Excel/Google Sheets | Critical & P-values
Переглядів 2,7 тис.7 місяців тому
Hypothesis t-test Template for mean in Excel/Google Sheets | Critical & P-values
Hypothesis Z-test for mean - Excel Template | Hypothesis Testing | critical & p-values
Переглядів 4,2 тис.7 місяців тому
Hypothesis Z-test for mean - Excel Template | Hypothesis Testing | critical & p-values
Binary Integer LP - Capital Budgeting - Formulation + Solution
Переглядів 4,5 тис.7 місяців тому
Binary Integer LP - Capital Budgeting - Formulation Solution
Solving Math/Stats Problems in Microsoft Copilot - Bing Chat - Prompt Engineering basics
Переглядів 1,4 тис.8 місяців тому
Solving Math/Stats Problems in Microsoft Copilot - Bing Chat - Prompt Engineering basics
Decision Analysis - Sensitivity Analysis | Find p | Draw Graph | Data Table in Excel
Переглядів 7 тис.9 місяців тому
Decision Analysis - Sensitivity Analysis | Find p | Draw Graph | Data Table in Excel
Solved - Hypothesis - Proportion Test | Z test, P-value | First-time home buyers
Переглядів 21 тис.9 місяців тому
Solved - Hypothesis - Proportion Test | Z test, P-value | First-time home buyers
Construct Horizontal Boxplot | Excel + PowerPoint to Word
Переглядів 6 тис.9 місяців тому
Construct Horizontal Boxplot | Excel PowerPoint to Word
Hypothesis Testing 2-tailed: Solved Problem: Quiz 10#5
Переглядів 4,6 тис.10 місяців тому
Hypothesis Testing 2-tailed: Solved Problem: Quiz 10#5
Calculating Bond Value (Price) | Formula | Excel | BA II Plus calculator
Переглядів 5 тис.10 місяців тому
Calculating Bond Value (Price) | Formula | Excel | BA II Plus calculator
Special LP Cases in Simplex Method | Infeasibility, Alternative Solutions, Unboundedness, Degeneracy
Переглядів 18 тис.10 місяців тому
Special LP Cases in Simplex Method | Infeasibility, Alternative Solutions, Unboundedness, Degeneracy

КОМЕНТАРІ

  • @nikkiweas7560
    @nikkiweas7560 11 годин тому

    Thank you so much! I was struggling until I saw this video. Easy to follow!

    • @joshemman
      @joshemman 9 годин тому

      You're welcome, Nikki.

  • @SundusAbdalle
    @SundusAbdalle 18 годин тому

    Thanks🎉

  • @OG_Chaleb
    @OG_Chaleb День тому

    Explained like a Lion🦁

  • @razzxzyzyz2688
    @razzxzyzyz2688 День тому

    How did it become -13 = - 20 and how did it become Y= 1.54??

  • @alansinclair4020
    @alansinclair4020 2 дні тому

    Excellent presentation clearly explaining integer LP. Thanks a lot.

    • @joshemman
      @joshemman 2 дні тому

      You're welcome, Alan.

  • @elliesalt5701
    @elliesalt5701 4 дні тому

    thank you so much for being so straightforward

  • @mayalightfoot8703
    @mayalightfoot8703 4 дні тому

    if i have my calculator programmed would the inverse of my final maximization problem = the minimum?

    • @joshemman
      @joshemman 4 дні тому

      If your calculator is set to Maximize, and you want to Minimize, you can simply multiply the objective function by -1, then Maximize. After obtaining the objective function value (no the optimal solution point), you will then need to multiply it by -1.

  • @peterdominic536
    @peterdominic536 4 дні тому

    Well explained ❤

  • @nurb8685
    @nurb8685 5 днів тому

    finally made sense to me

    • @joshemman
      @joshemman 4 дні тому

      Glad it helps. Thanks for dropping a note.

  • @kamalthelegendkiller
    @kamalthelegendkiller 5 днів тому

    Thank you Sir. Appreciate your video!

    • @joshemman
      @joshemman 4 дні тому

      You're welcome, Kamal.

  • @JencyVincent
    @JencyVincent 5 днів тому

    Please explain me how to get X and Y in for all equation

  • @JencyVincent
    @JencyVincent 5 днів тому

    Please explain me how to get X and Y in for all equation

  • @JencyVincent
    @JencyVincent 5 днів тому

    Please explain me how to get X and Y in for all equation

  • @aniketmg
    @aniketmg 6 днів тому

    true name joshua... really helpful

    • @joshemman
      @joshemman 5 днів тому

      You're welcome, Aniket.

  • @Leader01
    @Leader01 6 днів тому

    هلا🎉

  • @abdiFUNNYMOMENENTS
    @abdiFUNNYMOMENENTS 7 днів тому

    Not good explainations

  • @olamidesubair4953
    @olamidesubair4953 7 днів тому

    When n is greater than 30 ain’t you supposed to use z table???

    • @joshemman
      @joshemman 6 днів тому

      Some texts use Z when n > 30, and some don't. If your course says use Z, then do it.

  • @KobbyChief
    @KobbyChief 7 днів тому

    will they give you the standard normal table or you will solve for it?

    • @joshemman
      @joshemman 7 днів тому

      Normally you're given the table. Otherwise, you can use software to obtain the values.

  • @user-on2dj1mz2c
    @user-on2dj1mz2c 7 днів тому

    Very effective and clear!!! You are a wonderful teacher!!👍

  • @YourHeartFeelings
    @YourHeartFeelings 7 днів тому

    Thank you very much

  • @brightsoko1618
    @brightsoko1618 7 днів тому

    Wow thank you so much this was so helpful

  • @tathianaarones380
    @tathianaarones380 9 днів тому

    thank you!!!

    • @joshemman
      @joshemman 9 днів тому

      You're welcome, Tathiana.

  • @harshavardhan-ee6jd
    @harshavardhan-ee6jd 9 днів тому

    Quality content

  • @muskan__halder
    @muskan__halder 10 днів тому

    Thank you!

    • @joshemman
      @joshemman 9 днів тому

      You're welcome, Muskan.

  • @brianxyz
    @brianxyz 10 днів тому

    Great overview!

  • @caralu5771
    @caralu5771 10 днів тому

    concise and helpful. thank you

    • @joshemman
      @joshemman 10 днів тому

      YOu're welcome, Caralu.

  • @LukaszM180
    @LukaszM180 10 днів тому

    Thanks to you I passed an exam <3

  • @AsefaAsefa-ws3oe
    @AsefaAsefa-ws3oe 10 днів тому

    The peace care Hospital uses 3500 boxes of sterile bandages each month.The annual carrying cost is $2.90 per box per year.The ordering cost $25 each an order placed,regardless of the order quantity.The hospital operate365 day per year .peace care Hospital would like to use the EOQ model

    • @joshemman
      @joshemman 10 днів тому

      "peace care Hospital would like to use the EOQ model" to find what?

  • @user-vz9ve3pf1s
    @user-vz9ve3pf1s 11 днів тому

    thanks

  • @EmEpsilon
    @EmEpsilon 11 днів тому

    the formula in cell e2 gives error message on my excel. There is no mistake in what we do but it just does not work

    • @joshemman
      @joshemman 11 днів тому

      Make the cells are either empty or contain only numbers, then try this pasting this: =SUMPRODUCT(B3:D3,B2:D2)

  • @pponyooo
    @pponyooo 11 днів тому

    How can we find cost of capital if not provided in the question?

  • @kenbhho3486
    @kenbhho3486 12 днів тому

    Bro, Predecessor is missing help guide, what are you doing

    • @joshemman
      @joshemman 12 днів тому

      I'm not clear what you mean by predecessor missing. Can you explain or state the full question.

  • @kenbhho3486
    @kenbhho3486 12 днів тому

    Please Like Here how many of you came when your exam is tomorrow or next day, to Learn about PERT methord, finding the CP

  • @alexandrosioannidis7129
    @alexandrosioannidis7129 12 днів тому

    I love you, thank u so much you have saved my exams! Much appreciated!

    • @user-kx7uq1hx3u
      @user-kx7uq1hx3u 12 днів тому

      he saved me from everything. meng i love u

  • @simphiwesanele8038
    @simphiwesanele8038 12 днів тому

    What a great explanation. Thank you man. May God bless you🙏🏾.

  • @user-hm2vk5uz1l
    @user-hm2vk5uz1l 13 днів тому

    I am excited! Thank you!

  • @user-hm2vk5uz1l
    @user-hm2vk5uz1l 13 днів тому

    So clear! Thank you!

  • @Jerrel.A
    @Jerrel.A 14 днів тому

    Thank you Mr. Joshua Emmanuel for the most effective explanation on this subject.

  • @bonidel3713
    @bonidel3713 15 днів тому

    I passed my decision science and industrial engineering classes with an A because of you ❤

    • @joshemman
      @joshemman 15 днів тому

      Happy for you. Thanks for taking the time to drop a note. 🙏

  • @tendayimashingaidze7577
    @tendayimashingaidze7577 16 днів тому

    Linkden or email address Joshua?

    • @joshemman
      @joshemman 15 днів тому

      You can check this channel's ABOUT section or do a Google Search.

  • @ali_hussain8772
    @ali_hussain8772 16 днів тому

    Great sir... Its very helpful We got it easily❤

    • @joshemman
      @joshemman 15 днів тому

      Great 👍 Thanks.

  • @MegaDivalious
    @MegaDivalious 17 днів тому

    Wow, you made this exponentially easier to understand. Thank you, Professor!

    • @joshemman
      @joshemman 15 днів тому

      You're very welcome, Nmachi!

  • @sumanrautela3261
    @sumanrautela3261 17 днів тому

    Forecast ❌ Fuckass ✅

  • @olanrewajuseunemmanuel8356
    @olanrewajuseunemmanuel8356 17 днів тому

    Thank you Joshua

    • @joshemman
      @joshemman 15 днів тому

      You're welcome, Seun.

  • @ALEXANDROSCHATZIXENITIDIS
    @ALEXANDROSCHATZIXENITIDIS 18 днів тому

    Mate GOD BLESS YOU

    • @joshemman
      @joshemman 17 днів тому

      Bless you too, Alexandros. 🙏

  • @kozaTG
    @kozaTG 18 днів тому

    the whole public education system can be replaced by youtube

  • @JAG_158
    @JAG_158 18 днів тому

    Explain Why it is a TWO TAIL (0.025) and not One Tail (0.05). Much appreciated

    • @joshemman
      @joshemman 18 днів тому

      By default a 95% confidence level is located in the middle of the distribution, leaving 0.05 area which is divided equally (.025) into the two tails.

    • @JAG_158
      @JAG_158 17 днів тому

      @@joshemmanif i could rephrase, there are a few questions i’ve seen where one tail (a) is used instead of (a/2) such as a below or above average comparison. Could you explain when that is used?

    • @joshemman
      @joshemman 17 днів тому

      @@JAG_158 See if this helps: ua-cam.com/video/Iv1RQnjV-1U/v-deo.html

  • @itstaiba3005
    @itstaiba3005 18 днів тому

    Omg thank you so much 🫶🏽. I’ve trying to solve this particular question for sometime now

    • @itstaiba3005
      @itstaiba3005 18 днів тому

      Does this mean the critical path is the same as the finish

    • @joshemman
      @joshemman 18 днів тому

      @@itstaiba3005 As stated at 6:46, the critical is the path: B-D-E-F. The finish time however is 32 weeks.

    • @itstaiba3005
      @itstaiba3005 18 днів тому

      @@joshemman yes, but I was told if the total for your critical path is not the same as your finish time then it’s wrong. In this case the finish time is 32 and the total for critical path is also 32

    • @joshemman
      @joshemman 18 днів тому

      @@itstaiba3005 that's correct!

    • @itstaiba3005
      @itstaiba3005 18 днів тому

      @@joshemman alright. Thank you, I appreciate it

  • @C39SHARKDRAKE
    @C39SHARKDRAKE 18 днів тому

    Thanks for your Help Joshua <3!😎

    • @joshemman
      @joshemman 18 днів тому

      You're welcome, Cal. 🙏

  • @tehzeebghulamhussain8765
    @tehzeebghulamhussain8765 18 днів тому

    u look like deji

    • @joshemman
      @joshemman 18 днів тому

      Ok. Say hi to Deji then. 😄