3200+ entries in 0.007s
mod6: yeah, looking at 10.4
mod6: gonna read through the steps again
mod6: I'm on step 10.4 here... having some trouble.
mod6: I think I'm alright with that, again, if it's considered a "notional" number.
mod6: ahh, alright. i get what you mean. so it's a bit simpler to just get the forex number at the time of the statement, rather than having to old up the previous months statement until a BTC/USD price point is established.
mod6: ok np at all, just trying to get the process of getting these numbers. take your time. i feel like I'm learning a lot here with all of this, it's super helpful.
mod6: and btw, the steps are very helpful! thank you much for writing themup
mod6: i was just following your steps, and since it was actually in use, figured that maybe we just forgot about it.
mod6: ok so now that i've figured out that cash number from the Assets table, there will still two other questions for you above ^ when you get a chance: the depreciation of UY3, and the sum of the book values.
mod6: i honestly think that would be a much clearer accounting way to go.
mod6: i've thought about it. maybe further discussion around the topic will help change my mind.
mod6: it would be nice if pizarro had it's own key and could keep it's own ledger, but then who would control or hold said key, and that doesn't work either.
mod6: well, at lesat, until I send them to BingoBoingo, in which case, he might have his own subtraction he'll have to do. that's the messiest part of doing the pizarro thing through personal deedbot accounts.
mod6: must be subtracted out from here on out.
mod6: it's the amount that mod6 himself had in his deedbot account before I was sent Pizarro's 6.21445021 BTC.
mod6: perfect, that's exactly the number I was looking for.
mod6: !Qcalc (6.14882560-0.08479669)+0.22505299+0.2
mod6: or just the fiat or other cash lines?
mod6: Anyway, take your time, I'm gonna keep going here.
mod6: For my notes, could we say, in general, that to get to this month-end cash asset number, you take the BTC amount on-hand + USD value in BTC + UYU value in BTC?
mod6: (im adding that in, because even though it was paid on 8/3 it belongs in the July statement - as you have also listed it in the BTC Incoming/Outgoing table.
mod6: !Qcalc (6.14882560-0.08479669)+0.22505299+0.19308823+0.21648971
mod6: the 0.22505299 wasn't included there, lemme try again
mod6: So the nubmber im using '6.14882560' is from my ledger after Mr. Popescu paid the S.MG UY3
mod6: !Qcalc (6.14882560-0.08479669)+0.19308823+0.21648971+.2
mod6: im using your UYU value actually. (i'm only pointing out the differences, not using them in the calcs)
mod6: ben_vulpes: gotcha. any idea what number you used? This should go into my notes so I know to record the UYU/USD exchange rate at the time of the setting of the monthly price point.
☟︎ mod6: So we're close here, but not quite to the 6.48908190 that is in the table
mod6: !Qcalc (6.14882560-0.08479669)+0.19308823+0.21648971
mod6: !Qcalc ((((6.14882560-0.08479669)+0.19308823)+0.21648971)
mod6: Here's what I come up with on my own, would be the Sum of the BTC on hand (in mod6's deebot account, minus the 0.08479669 that was in there previously to pizarro's BTC deposit), plus the BTC book value of the USD, and the BTC book value of the UYU:
mod6: Ok, first question on this part is how we got to the 7/31/2018 (end of july) cash amount of: 6.48908190
mod6: Ok now actually moving on to Pizarro Assets table.
mod6: Ok we're not getting the same sum of the tangible book values, did I add something in that I wasn't supposed to?
mod6: !Qcalc 0.14906164+0.30000001+0.08109780+0.55312191+0.38888892+0.19308823+0.21648971+0.25106448
mod6: Before I do that, I forgot to sum the values in the book value column in the Tangibles table
mod6: Ok moving on to the Pizarro Assets table
mod6: ^ Full month depreciation would be this.
mod6: !Qcalc 0.55312191/12
mod6: This make sense for book value after prorated depreciation (fist number). Second number is the prorated depreciation.
mod6: !Qcalc (((0.55312191/12)/31)*19)
mod6: !Qcalc 0.55312191-(((0.55312191/12)/31)*19)
mod6: c-ya mircea_popescu
mod6: My only other question on the Tangibles table is that UY3 was not depreciated, even though it was in service for 19 days. Should there be some sort of prorated depreciation on this?
mod6: hmm. yeah, let me know on this one.
mod6: !Qcalc (44900*0.032)/6800
mod6: ben_vulpes: qq on the UYU book value -- you listed 0.21648971 , but I get the above ^ am I doing that correctly? Or am I using a bad UYU/USD number?
mod6: !Qcalc (44900*0.033)/6800
mod6: Yikes, here we go through the tangibles table. :D
mod6: The Fiat Liabilities table looks right -- My understanding here is that we have a $2500 entry here for the wildcat bonus because we initially allocated the wildcat bonus for $7500, paid out $5000, and are carrying the libility forward until it's paid September 1st. Correct ben_vulpes ?
mod6: The Fiat Assets table looks correct to me from following the steps, and when including the outgoing $186 adjustment value in the USD Incoming/Outgoing table.
mod6: Further more, he seems to like it as a good place to receive items. So maybe just strike the part that says "no further need for coworking desk" and edit to something like "expected reduction in cost for cowork desk" or something thereabouts.
mod6: So the USD Incoming/Outgoing table in the July provisional pizarro statement looks correct to me. The only thing I would adjust is the statement about Fiat expenses. Whereas, I agree that all the work could be done from the apartment and we no longer need the co-work space. I'm inclined to let BingoBoingo make the decision there, and it sounds like he wants to take it down to "part-time", which should red
mod6: will finish up the rest tomorrow (hopefully).
mod6: ben_vulpes: ok only had time today to start on reviewing the provisional july pizarro statement - going through your steps at the same time. so far, I can confirm the BTC incoming/outgoing is accurate.
mod6: BingoBoingo: any news on the drive shipment?
mod6: All: The price point for August is now set at $7454.54.
mod6: Alright, now everything should be straight.
mod6: !!v 686B8C99989197732D824C678EB37FEFE65F4D2B01A2259F85E38DE86FFD27EE
mod6: !!v FA8D85ADF1942C3ECF43C9FC1D7272AA88A0E50160C8451BC865F1BD46A8BE01
mod6: !!v 219DA25EE262A213C10A08827D05B276CD994D309FF1DC98178FB1EA80B8EC0C
mod6: !!invoice trinque 0.02200855 August Invoice for colocation service and shared shell at pizarro
mod6: !Qcalc (141.70/7454.54)+0.003
☟︎ mod6: !!invoice jurov 0.01900855 August Invoice for The Bitcoin Foundation's colo service. #foundation #pizarro
mod6: !!invoice jurov August 0.01900855 August Invoice for The Bitcoin Foundation's colo service. #foundation #pizarro
mod6: !Qcalc 141.70/7454.54
mod6: BingoBoingo: Monthly ^ for rockchip
mod6: BingoBoingo: Quarterly ^
mod6: !Qcalc (75+75+75)/7454.54
mod6: !!Qcalc (75+75+75)/7454.54
mod6: !!invoice mircea_popescu 0.057806595 August 2018 invoice for UY3
mod6: shit, I didn't even need to cancel the one for S.MG.
mod6: !!v 49444AD95AE10A40C8C274D2730499414909FC8998FDDAB306E6B04343BE58AE
mod6: !!v 89A1ED6A3F48C1CAEE02EE4F65A0BC3FD09F381B3D030C60CD118662FCF391B8
mod6: !!v F9B6E58EC6C6D82F22D1D81EAC8CC603B30A941E6FFA6A12A4D48845F120E27E
mod6: !!pay trinque 0.02028048
mod6: !!cancel-invoice jurov 3
mod6: !!cancel-invoice mircea_popescu 3