Hello,
I am doing a WACC project of Apple, Inc and trying to follow the instruction below, but I do not think it is clear enough for me to follow.
Calculating the Weighted Average Cost of Debt
I was able to pull all bonds info of Apple and try to input the data to excel workbook.
I am not sure which one goes to $ amt., price and YTM.
According to the instruction, YTM is coupon rate, if so, what YTM indicates on the bonds data. Also, can you please verify my par value? based on Apple 2018 10-K, par value is $0.00001.
Thanks
Regarding par value, it should be $1000. The $0.00001 value that you are referring is that of apple's equity share as given in their 10K.
Regarding $Amt
I believe you are trying to calculate the number of bonds issued using the formula ($ Amount/Par value). If that is the case the, $ amount will take in the total value of bond issue i.e. how much money was raised in a particular bond issue.
Price:
In the price column you will fill in the last sales price as given in the snips you have attached. The way bond quotes work is that the last sale price represents the market price as a percentage of the par value, $1000. For example, a quoted price of 103.250 means that the market price is $1,032.50 (103.250% of $1000). This is what is meant by the very first instruction " bond prices are quoted in 100s but are really 1000s). So, $1,032.50 will go into the price column.
If, however price is not quoted, you need to fill in the par value which is $1000.
Regarding YTM, you need to take the Yield figure quoted in the snips. Coupon rate will only be used in case the bond price is not given i.e. when you are using the par value as price. This is because when market prices are equal to the bond's par value, its yield equals the coupon rate.
Hope this helps!
Hello, I am doing a WACC project of Apple, Inc and trying to follow the instruction...
Hello, I am doing WACC project of Apple, Inc and unable to locate Mv Leases information. Per instruction, I should get the information in balance sheet but I can't find it. Please help me locate. Can you please also verify # of common share and common price number? Thanks Amount P Number YTM as a decimal Market Value S(Mil) 0.035 0.025 0.035 0.040 0.028 0.026 0.025 0.028 0.032 0.035 0.041 0.042 Weighted YTM 0.0004 0.0003 0.0008 0.0005 0.0003 0.0003 0.0003...
What does this graph mean and how can I interpret it? Relative Value Value relative to August 28, 2019 with 0% reference level 2019-09-20 2019-10-14 2019-11-11 2019-11-13 2019-11-15 2019-11-19 Date 2019-08-28 2019-08-30 2019-09-04 2019-09-06 2019-09-10 2019-09-12 2019-09-16 2019-09-18 2019-09-24 2019-09-26 201909-30 2049-10-02 2019-300 2019-10-08 2019 2020 2019 10-16 2019-10-18 10-22 2019-10-24 2019-10-28 2019-10-30 2019-11-01 2019-11-6 2019-11-07 PG Nike Facebook Portfolio
Please, clearly state what you are doing. a) Convert the data for each year into an approximate Average Annual Daily Traffic volume b) Using the survey data, determine the compounding growth rate of the road c) Determine the Average Annual Daily Traffic volume for the opening year of 2020 d) Determine the cumulative compound growth rate (CGR) for the design traffic? Date and Time Ch 1: Eastbound Left Lane Ch 2: Eastbound Right Lane Ch 3: Westbound Right Lane Ch...
Need help with C++ assignment Assignment 1 and .txt files are provided at the bottom. PART A PART B Assignment 1 #include <iostream> #include <string> #include <fstream> #include <iomanip> #include <stdio.h> #include <ctype.h> #include <string.h> #include <algorithm> using namespace std; /** This structure is to store the date and it has three integer fields **/ struct Date{ int day; int month; int year; }; /** This structure is to store the size of the box and it...
there is no header, i am only asking about number 5 and 6 but this is all that is given i think these are the proper headers, 3.375 and 8.375 are the annualized dividends, 3.276 and 2.301 are the yield. The yes/no portion of the table could be redeamable, perpetual, or communitive i dont know how to tell which one it is. IBM4035386 Yes Corporate Bond 3.375 08/01/2023 A3 AA 276 INTERNATIONAL BUSINESS MACHS CORP IBM.GT Corporate Bond 6.375 11/01/2010...
Code with Java using arrays and Scanner only ( input should end with 0 to terminate the program) Everyone loves to be celebrated on their birthdays. Birthday celebration can encourage positive social interaction among co-workers, foster friendship among classmates or even strengthen bond between families. Birthday graph can be display in many forms. It can a creative drawing consists of cupcakes, balloons, candles with names, or it can be in the form of simple bar chart to indicate the birthday...
Please use the following data to answer the questions. The ticker symbols are for Tesla Inc (TSLA), Barrick Gold Corporation (GOLD) and Apple Inc (AAPL). The prices shown are the closing stock prices for the date shown. Your first task is to compute the monthly holding period returns for each stock for each month, using the Holding Period Return formula, which is HPR = (P1 - P0)/P0, where P1 is the end of period price and P0 is the start...
Use the Journal Entries (Links to an external site.) for Tiger Inc to answer the following: What is the ending balance of Accounts Receivable? Group of answer choices a. 80,000 b. 120,000 c. 50,000 d. 40,000 B D E 1 Tiger Inc. Journal Entries N 3 02/01/2020 DR: Cash A 550,000 4. CR: Stock S 550,000 5 6 02/02/2020 DR: Inventory $ 30,000 7 CR: Cash $ 30,000 8 9 $ 80,000 02/03/2020 DR: Accounts Receivable CR: Revenyue 10 $...
Hello, I am using Microsoft 365 Excel to formulate a Gantt Chart. I was doing OK until I needed to insert the "Duration" data into the chart. I have viewed numerous Youtube videos and it appears those are older versions of Excel. Can you help? Unfortunately, your service does not allow me to send all my data at once. So, I will attempt to send it piecemeal. Thanks, Dianne Morefield Shoreline Stadium Case START DATE END DATE DESCRIPTION DURATION (days)...
Below are pictures of my HNMR and CNMR for salenH2. I have already assigned some of the protons and carbons myself, but I am having trouble with the rest. As far as I know, there are 8 unique carbons and 7 unique hydrogens. The carbons are numbered and the hydrogens are lettered. I have included a labeled picture of the compound on each page. CNMR overall: CNMR zoomed: HNMR overall: HNMR zoomed: Thanks! (thousandths) 0 2.0 4.0 6.0 8.0 10.0...