Upton Computers Pro forma balance sheet December 21, 2020 (Millions of d Particulars Calculation Amount Assets: Cash 4.235 A 3.5*1.21 Receivables 26*1.21 31.46

Q: Can you please explain the formula for row 9,10,11?

A: Using CAPM  formula:Rf+Beta * Risk premium for the market index return

Q: for step 2 when I calculate 1(1+.12)^6 I get 1.973822685 whereas you put it as 0.5066311. Can you…

A: You asked a question, and you have a solution in your hand. Unfortunately, you are not able to…

Q: calculations to these answers?

A: Cost allocation is the process of assigning or distributing the costs to different business units,…

Q: Can you explain the formula you used in C3?

A: Lets understand the basics.When bond is issued for more than its face value then bond is known to be…

Q: how do you do the math the get the percentage/decimal numbers

A: Income statement is the statement in which figures relating to entity performance is incorporated…

Q: if you can double check 1a and 1b 2a and i need answer 4 as well

A: A flexible budget is a kind of a budget that can be changed multiple times if the revenue or…

Q: name for the amount

A:

Q: What is simple interest

A: SOLUTION:   Simple interest is the method of calculating interest on a loan. It is calculated only…

Q: What do you mean by Count Data? When it arises?

A: Count data:  Count data is a kind of statistical data, in which the observations might only consider…

Q: What is a prime factorization? A) Expressing a number as a product of its prime factors B)…

A: Prime factorization is a process in mathematics. It involves expressing a number as a product of its…

Q: what assumptions did you make for 2a and explain

A: The dividend discount model (DDM), a mathematical technique for predicting the price of a company's…

Q: Is there a formula (not in excel) that can be used to calculate this?

A: We can use present value formula and present value annuity factor table to calculate number of…

Q: Please explain the calculation of C transactions

A: Retirement of bonds means the bonds which was issued earlier are retired. In simple, the amount is…

Q: Where does the information on step one comes from?

A: The excess of an asset's expected investment return above the risk-free rate of return is known as…

Q: Outline a quick method of multiplying a decimal by 100.

A:

Q: 2 decimals places are needed to answer this question.

A: According to Black Scholes Model, the option value is calculated as shown below.

Q: Can you please provide the calculations to get to this number.

A: The unified tax credit defines a dollar amount that an individual can gift during their lifetime and…

Q: how did you get the -68419 and -61272 in the fifo balance sheet

A: Cost of goods sold is the amount of cost which is assigned to the sold goods.  Taxes are calculated…

Q: Can you please show ALL the calculations in step 2?

A: Product mix: The product mix or product assortment refers to the total number of different product…

Q: confused on how the number for D is calculated

A: Bad debt is calculated on the value of sales receivable during the period.Bad debt is an expense…

Q: What IF function can be used to determine whether or not an amount in a certain cell should be a…

A: A journal entry is the first step in including a transaction into the books of accounts. Under the…

Q: what formula did you use to calculate PVIFA?

A: The acronym PVIFA stands for the present value interest factor. The present value interest factor is…

Q: rom where does 184.17 came in step 3

A: When a loan is taken then periodic payments has to be made. In this case and situation monthly…

Q: count ROCE

A: ROCE stands for Return on Capital Employed.

Q: Where does the 12 come from in the second step?

A: Sales price = Cost per unit + Profit per unit  Cost = Direct material + Direct labor + Manufacturing…

Q: or working for NPV and EAA calculation?

A: EAA is calculated as shown below. EAA=NPV×r1-11+rnHere,Cost of capital/ WACC=rLife of project=n

Q: When I type in that calculation is comes out as "0"   =PMT(B2/12,B3*12,-B1)

A: PMT function is a financial function of excel. It is used to compute the periodic payment amount.…

Q: How did you compute what the "R" value was in the equation?

A: IRR is the internal rate of return and is the break even rate of return at present value of cash…

Q: What number is cell D4 referring to on the first part of the question?

A: Given in the question: Annual Lease Payments at the beginning of year  $24,000 Lease…

Q: Which excel formula is this

A: Solution:- When an equal amount is withdrawn each period, it is known as annuity.

Q: Can you please provide the calculations that you used.

A: Current Assets - Current Assets is the assets which can convert into cash with in a span of one…

Q: Could you include the formulas used for all the blue squares.

A: The authorized capital is declared by the company on its memorandum at the time of company…

Q: How do I calculate FIFO and LIFO?

A: Meaning of FIFO:First in first out means if company purchases any goods for sale purpose then…

Q: Why do i need to divide by 2?

A: Given: The bonds make semiannual coupon payments

Q: what are the four perspectives of a balancerd score card explain with examples

A: Balanced scorecard (BSC) is performance measurement tool which is widely used by the different…